Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ants” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

401 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ants4724347(None) 
acts66929861acts
aits46355531aits
alts46639901alts
anas46649861anas
ands57833611ands
anes45255931anes
anis45746461anis
ant37270781ant_
anta46839581anta
antas55432031antas
ante46538901ante
antes56334321antes
anti45536361anti
antis55033311antis
antsy85712791antsy
anus47131111anus
arts49650261arts
aunts55227631aunts
cants77036941cants
hants86335401hants
pants76536921pants
rants55935341rants
wants87932211wants
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
abets75621672abets
abos67734412abos
abs59356072a_bs
abuts75417072abuts
abys97221882abys
aces67645092aces
acnes75922622acnes
act59557842act_
acta69524802acta
adds67622452adds
adits66523712adits
ados57633512ados
ads49755732a_ds
aft66849012aft_
agas55938842agas
agents74816292agents
ages55844592ages
ags47551662a_gs
ahis76135382ahis
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
airts55626342airts
ais39083572a_is
ait38093902ait_
alants67722022alants
alas46358122alas
albs68628572albs
ales47067102ales
alls46740922alls
alms65834922alms
alps65529242alps
als36663022a_ls
alt36467962alt_
alto47831262alto
altos55822952altos
amas67746292amas
aments85219802aments
amis66445312amis
amps86230342amps
amus65529612amus
an211879072an__
ana39559822an_a
anal48037522anal
and47244162an_d
ane37866942an_e
anew76623132anew
anga56831352anga
angas65827982angas
angst6415492angst
angsts738862angsts
ani37751172an_i
anil46437432anil
anils56326722anils
anise55129702anise
ankh111114412ankh
ankhs12116722ankhs
ankus91410682ankus
anlas55626932anlas
anna45529012anna
annas55824882annas
anoa45634472anoa
anoas57226492anoas
anon46134852anon
ansa45927772ansa
antae56828292antae
anted66328242anted
antic75728862antic
antics84621452antics
antra56521922antra
antre55224522antre
antres65021002antres
any68440482an_y
apes66047432apes
apos65433822apos
apps86319692apps
apt57352542apt_
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
ars37670932a_rs
art38679142art_
artsy86012962artsy
arty77531312arty
as211083072a__s
asks85721212asks
asps65622092asps
ass37844062a_ss
at212393402a_t_
ate37059242a_te
ates45047922ates
att35454652a_tt
auks85525262auks
aunt46553652aunt_
aunty85919812aunty
auto47432082auto
autos56523322autos
aves76142602aves
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
axes117337852axes
axis116127912axis
ayes76543512ayes
ays67050292a_ys
bahts105617802bahts
baits76630582baits
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555132ban_s
banty106624002banty
basts75936932basts
bats66962332bats
batts76727562batts
bents76033692bents
bets67051442bets
bints76130182bints
bits66148152bits
bots66453952bots
brants85723052brants
bunts75729802bunts
buts67247692buts
canes75350372canes
cans65050842can_s
canst74932212canst
cant66362022cant_
canto74931012canto
cantos84826972cantos
cantus85117762cantus
canty105226802canty
carts78946292carts
casts77237792casts
cats66356342cats
cents74730332cents
chants115020392chants
cots68054842cots
cunts76125122cunts
cuts65841152cuts
dangs75623202dangs
dans56748142dan_s
darts67635732darts
daunts75014082daunts
dauts67822242dauts
dawts97216122dawts
dents65031802dents
dints67431312dints
dits56450522dits
dots55647662dots
dunts65828412dunts
easts57530322easts
eats47054872eats
efts76519482efts
ends56528522ends
engs56121392engs
ens37245922en_s
facts107021892facts
faints94818782faints
fanes84639892fanes
fangs96224072fangs
fanos85926502fanos
fans76247362fan_s
farts88336842farts
fasts86429682fasts
fats76252502fats
fets75345942fets
fits76043462fits
fonts86124752fonts
gaits65726012gaits
gangs76222572gangs
gasts66628632gasts
gats56753442gats
gents65729612gents
gets55442482gets
giants74713502giants
gits55744592gits
gnats65217712gnats
gnus56518002gnus
grants73722472grants
guts56637252guts
haets86525122haets
hafts116219462hafts
haints94417582haints
halts85230102halts
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hant75461582hant_
harts88441592harts
hats76858252hats
haunts95614392haunts
hents87330742hents
hets75547202hets
hints87330622hints
hits75545132hits
hots78349322hots
hunts86826172hunts
huts76737442huts
inks86926502inks
inns46920932inns
ins35945602in_s
inti46626072inti
intis55121632intis
into45026152into
its35538832_its
janes124928122janes
janty156816962janty
jaunts137511882jaunts
jets115834102jets
jots116336142jots
juts115930162juts
kanas95326912kanas
kanes95529372kanes
karts97630112karts
kats85944332kats
kits86441762kits
knits93914742knits
knots95614722knots
lands65426902lands
lanes54946792lanes
lasts57731262lasts
lats45962702lats
lets47147942lets
lints57137192lints
lits46252492lits
lots47652092lots
lunts55826902lunts
malts76331752malts
manas76240422manas
manats84623462manats
manes76648952manes
manos74933612manos
mans66354532man_s
manta75629902manta
mantas85725362mantas
mantes84430782mantes
mantis83926032mantis
manus75924922manus
marts77442232marts
masts77035762masts
mats65460282mats
matts76829182matts
mauts75927192mauts
mints76834042mints
mots66853162mots
muts64839982muts
nabs66236192nabs
nags55436022nags
nanas55928632nanas
nans46139392nans
naos47429732naos
naps66238582naps
nates55238332nates
nays75931592nays
nets45941532nets
nits45741642nits
nos38859322_nos
nth66320592_nth
nus37939392_nus
nuts45032672nuts
oasts56529182oasts
oats46554212oats
ones46146532ones
onos46229002onos
ons36148512on_s
onto46127662onto
onus45826812onus
oots46446442oots
opts68124742opts
orts46538332orts
outs45746962outs
pacts95125802pacts
paints85921832paints
panes76148692panes
pangs84628662pangs
pans65855722pan_s
pant66061252pant_
panto76129412panto
pantos85222742pantos
panty105929302panty
parts77743372parts
pasts75936502pasts
pats66460852pats
pets66248332pets
pints75936222pints
pits66348742pits
plants84921802plants
pots66452362pots
punts75828002punts
puts65641752puts
qanats154112812qanats
qats135331342qats
quants153614142quants
rafts87820632rafts
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rant45864672rant_
rats46260372rats
rents55935182rents
rets45352562rets
rots46454092rots
runts55927632runts
ruts44541492ruts
saints65122422saints
salts55431882salts
sands65228582sands
sanes55649072sanes
sans45153352san_s
santo56227282santo
santos64421832santos
scants85219722scants
sets45549502sets
sits45050202sits
slants64819082slants
snits54124832snits
snots55225102snots
sots45552442sots
tacts76524122tacts
taints64520532taints
tangs65028342tangs
tanks94624732tanks
tans46154812tan_s
tanto55724942tanto
tarts57242022tarts
tats46858132tats
taunts65715662taunts
tauts56125512tauts
tents56434212tents
tets45847452tets
tints56030922tints
tits46145032tits
tots46654122tots
tuts45838452tuts
units54923432units
uns35936752un_s
unto45824282unto
uts35534372_uts
vanes85130972vanes
vangs96319582vangs
vans76236722van_s
vasts86423772vasts
vats76841742vats
vaunts95212622vaunts
vents86125932vents
vets76835092vets
wafts116920552wafts
waits88333522waits
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452262wan_s
want76156162want_
warts814840402warts
wasts87433672wasts
wats77555882wats
watts86923092watts
wets75940292wets
wits76044872wits
wonts87621542wonts
wots76342892wots
yangs95618692yangs
yanks125316572yanks
zits136030292zits

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.1231452772.4
2DLD Change Limit298724011.01629401.6
3Display Results4014010.0934311.8
 (SQL Overall)1786914011.232145041.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.