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

190 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
cantata9381180(None) 
cantala94114671cantala
cantatas103410081cantatas
canasta938362canasta
cantal84122032canta_l
cantalas104013522cantalas
cantals93919572cantals
cantina93417252cantina
cassata938142cassata
lantana739602lantana
tantara72410812tantara
acantha1254653acant_ha
acetate92514753acetate
albata839323_albata
anatto6139913_anatto
ansate64517863_ansate
anta46839583_an__ta
antae56828293_anta_e
antas55432033_anta_s
antitax1447853_antitax
antra56521923_ant_ra
balata8614663ba_lata
banana83213413ban_ana
bandana10179463bandana
bantam10314063banta_m
bantams1149063bantams
cabala103516913ca_bala
cabana103913563ca_bana
cabbala1367183cabbala
caftan111710123cafta_n
caftans12179443caftans
calamata1247543calamata
canal75428043can_a_l
canals84421663can_als
canape10913513can_ape
canard9314763can_ard
canary11314693can_ary
canastas1037693canastas
cancan10314103canca_n
cancans11311873cancans
cancha134411613can_cha
candela1089743candela
candida114110253candida
canella9310793canella
canna75919333can__na
cannas84518403canna_s
cannot83616773cannot_
cannula937433cannula
canola8313623can_ola
canst74932213can_st_
cant66362023can__t_
cantdog1134573cantdog
canted94825783cant_ed
canteen9411083canteen
canter85230113cant_er
canters94827723canters
canthal12410053canthal
canthi11310963cant_hi
canthus1248703canthus
cantic103920533cant_ic
cantinas102713773cantinas
canting104725903canting
cantle84522153cant_le
cantles94721413cantles
canto74931013can__to
canton85722993cant_on
cantonal1038903cantonal
cantons95221203cantons
cantor85621523cant_or
cantors94620753cantors
cantos84826973cant_os
cantraip12326383cantraip
cantrap113310273cantrap
cantraps12319113cantraps
cantrip112910033cantrip
cants77036943can__ts
cantus85117763cant_us
canty105226803can__ty
canula8312953can_ula
canulate10314543canulate
canvas113813333canva_s
canvass12376873canvass
canzona1836073canzona
capita102913773ca_pita
capitate121712183capitate
caponata1245153caponata
captain112111053captain
captan101613343capta_n
captans111612053captans
carat75048793ca_rat_
carate84734003ca_rate
carats85929023ca_rats
cartage10312593cartage
casaba1079263ca_saba
casava1157873ca_sava
cascara1138313cascara
caseate9314783caseate
casita82913703ca_sita
cassaba1145663cassaba
cassatas1036673cassatas
cassava1255003cassava
castaway1664573castaway
castrate10313863castrate
castrati1048643castrati
castrato1048523castrato
catalo8314853ca_talo
catalpa1136503ca_talpa
catawba1443703ca_tawba
catena8312473ca_tena
catnap1098383catna_p
catnaps1197033catnaps
cattail939173cattail
cattalo938423cattalo
catty104520413ca_t_ty
caudate10311353caudate
caveat11417723caveat_
caveats1239803caveats
cavitate13159833cavitate
centai84814783centa_i
cental84420963centa_l
centals94317053centals
centare93113703centare
centas85020703centa_s
centaur935783centaur
centavo1245103centavo
centra84113883cent_ra
chantage1446633chantage
commata1338483commata
connate9315753connate
contact1144020683contact
contacts123215213contacts
contagia1156773contagia
contain9315823contain
contra83314693cont_ra
costate94019273costate
cotta75818573c_ot_ta
craniate10312553craniate
cuneate9311723cuneate
curtate9312643curtate
cyanate12259703cyan_ate
dentate8315153dentate
fantail10310233fantail
fantasia1197013fantasia
fantasm1236593fantasm
fantast10311703fantast
fantasts1147113fantasts
fantasy1336153fantasy
gangsta944503gangsta
haftara13136093haftara
hastate10313913hastate
kanaka9357523kan_aka
kantar10311153kanta_r
kantars11310033kantars
lactate9312693lactate
lanate6421263lan_ate
lantanas838263lantanas
magmata1237453magmata
manana84816073man_ana
manat76039983man_at_
manats84623463man_ats
mandala10310203mandala
mandate10315573mandate
manta75629903man__ta
mantas85725363manta_s
mantra84116093mant_ra
mantua84412023mant_ua
mastaba1146223mastaba
panada94113053pan_ada
panama104213343pan_ama
partita9310863partita
pataca10311193pa_taca
pinata83817213pin_ata
pintada1096073pintada
qanat144426843qan_at_
qanats154112813qan_ats
ratatat7412263ra_tatat
sancta839833san_cta
sanitate8612043sanitate
santera7311303santera
satara6315533sa_tara
sonata6313223son_ata
tannate71813523tannate
tantaras8269533tantaras
tantra63713353tant_ra
tartana73010193tartana
vantage11109893vantage
wantage11119623wantage
xanthate1845713xanthate
yantra9449623yant_ra
zanana153810363zan_ana

Search took 8 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.1561145455.1
2DLD Change Limit1340271907.01619103.1
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.23524698.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.