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 “cants” 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.

353 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
cants7703694(None) 
ants47243471_ants
canes75350371canes
cans65050841can_s
canst74932211canst
cant66362021cant_
canto74931011canto
cantos84826971cantos
cantus85117761cantus
canty105226801canty
carts78946291carts
casts77237791casts
cats66356341ca_ts
cents74730331cents
chants115020391chants
cunts76125121cunts
hants86335401hants
pants76536921pants
rants55935341rants
scants85219721scants
wants87932211wants
acnes75922622acnes
acts66929862_acts
aits46355532_aits
alants67722022alants
alts46639902_alts
anas46649862_anas
ands57833612_ands
anes45255932_anes
anis45746462_anis
ant37270782_ant_
anta46839582_anta
antas55432032_antas
ante46538902_ante
antes56334322_antes
anti45536362_anti
antis55033312_antis
antsy85712792_antsy
anus47131112_anus
arts49650262_arts
aunts55227632aunts
bahts105617802bahts
baits76630582baits
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555132ban_s
banty106624002banty
basts75936932basts
bats66962332ba_ts
batts76727562batts
bents76033692bents
bints76130182bints
brants85723052brants
bunts75729802bunts
cabs86739422ca_bs
cacas95627982cacas
cacti9318632cacti
cactus104912232cactus
cades85440732cades
cadets96316502cadets
cadis84428492cadis
cads76144522ca_ds
cafes106426922cafes
caffs135417372caffs
cages85936012cages
caids85226422caids
cains75334302cains
cakes116037672cakes
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
camas96333522camas
cames97047312cames
camos95927612camos
camps116330262camps
cams87047282ca_ms
can57760132can__
canal75428042canal
canals84421662canals
candy115119822candy
cane66653112can_e
caned85838092caned
caner75334772caner
caners84629192caners
canid85526342canid
canids95118132canids
canna75919332canna
cannas84518402cannas
canny105817692canny
canoe75627252canoe
canoes84725882canoes
canon74725302canon
canons85522062canons
canso75019402canso
cansos84915382cansos
cantal84122032cantal
cantals93919572cantals
canted94825782canted
canter85230112canter
canters94827722canters
canthi11310962canthi
canthus1248702canthus
cantic103920532cantic
cantle84522152cantle
cantles94721412cantles
canton85722992canton
cantons95221202cantons
cantor85621522cantor
cantors94620752cantors
canvas113813332canvas
capes95441922capes
caphs124515372caphs
capos94826072capos
caps87147892ca_ps
carats85929022carats
carbs96031462carbs
cards85137932cards
cares77369182cares
carets85330772carets
carks115534212carks
carls77037422carls
carnets93918402carnets
carns75937562carns
carps96932252carps
carrs75730852carrs
cars67364762ca_rs
cart66570342cart_
carte75940422carte
cartes86239472cartes
casas75327842casas
cases75048382cases
casks115720062casks
cast67159902cast_
caste75932362caste
castes85631862castes
casus76419252casus
cat58282342ca_t_
cate66254592ca_te
cates75951872cates
catty104520412catty
cauls75727772cauls
caves105639702caves
caws96036102ca_ws
cays95437672ca_ys
celts75325782celts
cent67451012cent_
centas85020702centas
cento76625172cento
centos85920462centos
centu76119412centu
changs125215372changs
chant105932692chant_
chanty145215822chanty
charts115823092charts
chats105730092chats
chaunts1267082chaunts
chints115117832chints
chits105424572chits
cines75239682cines
cists76624532cists
clangs95113612clangs
clanks124615182clanks
clans75031012clan_s
clasts84817292clasts
clots75627642clots
coacts105314322coacts
coapts104614002coapts
coasts85719132coasts
coats75634992coats
colts76633292colts
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692con_s
conte76633202conte
contes84432912contes
conto76027172conto
contos84923232contos
conus76726532conus
coots75636842coots
costs77231142costs
cots68054842c_ots
counts84618272counts
crafts115312742crafts
cranes84330752cranes
cranks125015312cranks
crits75527572crits
cults75022552cults
cunt66243672cunt_
cuts65841152c_uts
cyans105714812cyan_s
cysts105912772cysts
dangs75623202dangs
dans56748142dan_s
darts67635732darts
daunts75014082daunts
dauts67822242dauts
dawts97216122dawts
decants103514442decants
dents65031802dents
dints67431312dints
dunts65828412dunts
easts57530322easts
eats47054872ea_ts
facts107021892facts
faints94818782faints
fanes84639892fanes
fangs96224072fangs
fanos85926502fanos
fans76247362fan_s
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
fonts86124752fonts
gaits65726012gaits
gangs76222572gangs
gasts66628632gasts
gats56753442ga_ts
gents65729612gents
giants74713502giants
gnats65217712gnats
grants73722472grants
haets86525122haets
hafts116219462hafts
haints94417582haints
halts85230102halts
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hant75461582hant_
harts88441592harts
hats76858252ha_ts
haunts95614392haunts
hents87330742hents
hints87330622hints
hunts86826172hunts
incants92012802incants
janes124928122janes
janty156816962janty
jaunts137511882jaunts
kanas95326912kanas
kanes95529372kanes
karts97630112karts
kats85944332ka_ts
lands65426902lands
lanes54946792lanes
lasts57731262lasts
lats45962702la_ts
lints57137192lints
lunts55826902lunts
malts76331752malts
manas76240422manas
manats84623462manats
manes76648952manes
manos74933612manos
mans66354532man_s
manta75629902manta
mantas85725362mantas
mantes84430782mantes
mantis83926032mantis
manus75924922manus
marts77442232marts
masts77035762masts
mats65460282ma_ts
matts76829182matts
mauts75927192mauts
mints76834042mints
nanas55928632nanas
nans46139392nan_s
oasts56529182oasts
oats46554212oa_ts
octants9128732octants
pacts95125802pacts
paints85921832paints
panes76148692panes
pangs84628662pangs
pans65855722pan_s
pant66061252pant_
panto76129412panto
pantos85222742pantos
panty105929302panty
parts77743372parts
pasts75936502pasts
pats66460852pa_ts
pints75936222pints
plants84921802plants
punts75828002punts
qanats154112812qanats
qats135331342qa_ts
quants153614142quants
rafts87820632rafts
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rant45864672rant_
rats46260372ra_ts
recants93217092recants
rents55935182rents
runts55927632runts
saints65122422saints
salts55431882salts
sands65228582sands
sanes55649072sanes
sans45153352san_s
santo56227282santo
santos64421832santos
scans74625102scan_s
scant79735072scant_
scanty114014662scanty
scarts85321492scarts
scats75930602sca_ts
scatts85914662scatts
scents85317022scents
secants93413892secants
slants64819082slants
tacts76524122tacts
taints64520532taints
tangs65028342tangs
tanks94624732tanks
tans46154812tan_s
tanto55724942tanto
tarts57242022tarts
tats46858132ta_ts
taunts65715662taunts
tauts56125512tauts
tents56434212tents
tints56030922tints
vanes85130972vanes
vangs96319582vangs
vans76236722van_s
vasts86423772vasts
vats76841742va_ts
vaunts95212622vaunts
vents86125932vents
wafts116920552wafts
waits88333522waits
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452262wan_s
want76156162want_
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
wonts87621542wonts
yangs95618692yangs
yanks125316572yanks

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 Filter178691538000.0931921408.6
2DLD Change Limit538003531.75030742.9
3Display Results3533530.0933795.7
 (SQL Overall)1786913531.93692299.1
 
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.