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

150 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
cantatas10341008(None) 
cantalas104013521cantalas
cantata93811811cantata_
canastas1037692canastas
cantala94114672cantala_
cantals93919572canta_ls
cantinas102713772cantinas
cassatas1036672cassatas
lantanas838262lantanas
tantaras8269532tantaras
acetates102013063acetates
albatas938373_albatas
anabas8314083_an_abas
anatase738943_an_atase
anattos7138453_anattos
annates72415423_annates
antas55432033_an__tas
antitax1447853_antitax
balatas9311833ba_latas
bananas93312223ban_anas
bandanas11178573bandanas
bantams1149063banta_ms
cabalas113516003ca_balas
cabanas112413033ca_banas
cabbalas1467373cabbalas
caftans12179443cafta_ns
calamatas1345783calamatas
canals84421663can_a_ls
canapes111213083can_apes
canards10311203can_ards
canasta938363canasta_
cancans11311873canca_ns
canchas143212403can_chas
candelas1139533candelas
candidas12338643candidas
canellas10310563canellas
cannabis1266033cannabis
cannas84518403can__nas
cannulas1037583cannulas
canolas9313993can_olas
cantal84122033can__tal
cantdogs1244043cantdogs
canteens1038573canteens
canters94827723cant_ers
canthal12410053cant_hal
cantharis1447173cantharis
canthitis1445273canthitis
canthus1248703cant_hus
cantina93417253cantina_
cantles94721413cant_les
cantonal1038903cantonal
cantons95221203cant_ons
cantors94620753cant_ors
cantos84826973can__tos
cantraips13255263cantraips
cantrap113310273cant_rap
cantraps12319113cantraps
cantrips12318923cantrips
cants77036943can__t_s
cantus85117763can__tus
canulas9312853can_ulas
canulates11312863canulates
canvas113813333can__vas
canvases13349513canvases
canvass12376873canva_ss
canzonas1935383canzonas
caponatas1343903caponatas
captains121810573captains
captans111612053capta_ns
carates95630603ca_rates
carats85929023ca_rat_s
caritas93316943ca_ritas
cartages11313313cartages
casabas1139983ca_sabas
casavas1237813ca_savas
cascaras1237693cascaras
caseates10313703caseates
casitas93312043ca_sitas
cassabas1245733cassabas
cassata938143cassata_
cassavas1344803cassavas
castaway1664573castaway
castaways1743673castaways
castrates11312663castrates
castratos1147633castratos
catalase1039213ca_talase
catalos9414163ca_talos
catalpas1246733ca_talpas
catawbas1544093ca_tawbas
catenas9313103ca_tenas
catnaps1197033catna_ps
cattails1038553cattails
cattalos1037933cattalos
caudates11310253caudates
caveats1239803caveat_s
cavitates14168963cavitates
centals94317053centa_ls
centares102913893centares
centas85020703cen__tas
centaurs1035723centaurs
centavos1344783centavos
chantages1546583chantages
conatus9310463con_atus
contacts123215213contacts
contains10316533contains
contras93015603cont_ras
cottas84615573c_ot_tas
craniates11310653craniates
cyanates13238423cyan_ates
fantails1139693fantails
fantasias1286993fantasias
fantasms1345633fantasms
fantasts1147113fantasts
gangstas1044403gangstas
haftaras14136073haftaras
kanakas10327213kan_akas
kantars11310033kanta_rs
lactates10311223lactates
lantana739603lantana_
mananas93414733man_anas
manats84623463man_at_s
mandalas1139433mandalas
mandates11314093mandates
mantas85725363man__tas
mantras93815863mant_ras
mantuas93410993mant_uas
mastabas1246803mastabas
panadas103312213pan_adas
panamas113112753pan_amas
partitas10310253partitas
patacas11311003pa_tacas
pinatas93711483pin_atas
pintadas11105063pintadas
qanats154112813qan_at_s
ratatat7412263ra_tatat
ratatats846063ra_tatats
sanitates9611733sanitates
santeras8311053santeras
sataras7315053sa_taras
sonatas7510293son_atas
tannates81911953tannates
tantalus836373tantalus
tantara72410813tantara_
tantras73112093tant_ras
tartanas8258893tartanas
vantages12119023vantages
wantages12109023wantages
xanthates1945653xanthates
yantras10259003yant_ras
zananas16319563zan_anas

Search took 9 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 Filter1786911461620.233766914.2
2DLD Change Limit1461621507.79618748.3
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.09222082.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.