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 “kaftans” with Change Limit: [1] [2] [3]

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

195 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
kaftans1418535(None) 
caftans12179441caftans
kaftan13185821kaftan_
caftan111710122caftan_
captans111612052captans
kalians11310182kalians
kanbans1337722kanbans
kantars11310032kantars
katas95922092ka_ta_s
partans94418282partans
ratans63819372ra_tans
rattans73411952rattans
tartans72615822tartans
actins86321103_actins
afars85716513_af_ars
afghans1443573_afghans
afters94717073_afters
alans55636173_a_lans
altars64518153_altars
antas55432033_anta_s
ataps76414833_a_taps
atmans84413963_atmans
attains7310983_attains
attars64515313_attars
avians93711563_avians
azans146516883_a_zans
banians9312033banians
bantams1149063bantams
banyans1237913banyans
batons85519423ba_tons
battens95313263battens
caftaned1445093caftaned
caimans113811783caimans
callans94518473callans
cancans11311873cancans
cantals93919573cantals
cantons95221203cantons
capstans1257243capstans
captains121810573captains
captan101613343captan_
cartons94122473cartons
caymans14349513caymans
cotans81317923_cotans
daltons8310403daltons
damans94715983da_mans
fans76247373__f_ans
fastens105511753fastens
fattens105111713fattens
flans85327973__flans
habitans1346623habitans
haftara13136093haftara
haftaras14136073haftaras
hafters134614333hafters
hafting144014173hafting
hafts116219463haft__s
haptens124511343haptens
hartals10313023hartals
hastens106214813hastens
hazans183411653ha_zans
hazzans18215783hazzans
japans1539823ja_pans
jawans1657843ja_wans
kaas86531843ka__a_s
kababs14409773ka_babs
kabars124513953ka_bars
kaffirs17325553kaffirs
kafirs13306983kaf_irs
kafs116423743kaf___s
kahunas1473953kahunas
kaiaks937043ka_iaks
kains96125643ka__ins
kakas85117343ka_ka_s
kalams12310603ka_lams
kalian10312163kalian_
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
kamsins1346963kamsins
kanas95326913ka_na_s
kanban1238623kanban_
kantar10311153kanta_r
kaolins1139363kaolins
kaons95014853ka__ons
kapas116021733ka_pa_s
kappas144410363kappa_s
karates115617473karates
karats106420493ka_rats
karmas123013733karma_s
karns96624143ka__rns
karting123716063karting
kartings13418523kartings
karts97630113kart__s
kasbahs1634363kasbahs
kashas133311903kasha_s
kata85626023ka_ta__
kations114013663kations
kats85944333ka_t__s
kavas125919953ka_va_s
kavass13517303ka_vass
kayaks1236333ka_yaks
khans124615173k__hans
kittens11347583kittens
koans95818623k__oans
krafts13438853kraft__s
kurgans12145653kurgans
kurtas10349883kurta_s
lactams1136953lactams
lagans75717783la_gans
lallans74113533lallans
lantana739603lantana
lantanas838263lantanas
latens64620213la_tens
lattens75014673lattens
lattins74115483lattins
lauans65113533la_uans
mafias113913573mafia_s
maftirs1236043maftirs
magians10310753magians
mannans93611523mannans
mantas85725363manta_s
martens93714953martens
martians103111613martians
martins93322063martins
matins84527783ma_tins
mattins93316143mattins
naans55815253na__ans
natant6318733na_tant
octans81411143_octans
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
parians93519733parians
partan83820563partan_
partons94620513partons
pastas85422873pasta_s
patens84820863pa_tens
patins87528783pa_tins
pattens95414923pattens
pavans115715593pa_vans
platans93413123platans
quartans1736283quartans
radians83013823radians
rafters103715633rafters
rafting113815753rafting
rafts87820633raft__s
raglans82410133raglans
ragtags935373ragtags
raitas64417673raita_s
randans8313213randans
ratals64219583ra_tals
ratan53722663ra_tan_
ratany93411873ra_tany
rattan63613603rattan_
rattens74213403rattens
rattons73815323rattons
saltant7316773saltant
saltpans1034813saltpans
sampans112411003sampans
sarans64224433sa_rans
satang75711563sa_tang
satangs8479713sa_tangs
satays94411683sa_tays
satins64930483sa_tins
seitans73312303seitans
sextans14349263sextans
shaitans1136413shaitans
softas94410403softa_s
softens10347623softens
sultans72411833sultans
suntans72111733suntans
tafias93111963tafia_s
taipans9269553taipans
tampans113310983tampans
tans46154823___tans
tarpans92513533tarpans
tartan64217513tartan_
tartana73010193tartana
tartanas8258893tartanas
tartars73313403tartars
tarzans16329923tarzans
tatars64619793ta_tars
tautens7317843tautens
titans63414913_titans
waftage14115323waftage
waftages15105393waftages
wafters134112813wafters
wafting143911663wafting
wafts116920553waft__s
wangans1149503wangans
wantons103713013wantons
wataps11248683wa_taps
witans93412933_witans
xanthans1845693xanthans
zaffars22325233zaffars

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271955.97022450.1
3Display Results1951950.0603250.0
 (SQL Overall)1786911956.43627764.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.