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

120 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
candidas1233865(None) 
candida114110251candida_
candidal12367741candidal
candids113812691candid_s
candelas1139532candelas
candid104517852candid__
candidacy1852362candidacy
candidate1356662candidate
candidates1446302candidates
candider1237342candider
candidest1346532candidest
candidly1545212candidly
candies104125612candi_es
canids95118132can_id_s
cantinas102713782cantinas
cardias10715122cardi_as
nandinas936582nandinas
scandias1137862scandi_as
acedias1039773acedi_as
anginas8310953_anginas
animas84418723_an_imas
bandanas11178573bandanas
bandas95120543ban__das
bandies104124863bandi_es
banditos11347633banditos
bandits103814793bandi_ts
bandoras1138743bandoras
caddices14297853caddices
caddies113718383caddi_es
caddis104613383ca_d_dis
caddises12329353caddises
cadis84428503ca_di__s
caids85226423ca__id_s
calderas1147883calderas
camisas113411923ca_misas
canards10311203canard_s
canastas1037693canastas
canchas143212403can_chas
candela1089743candela_
candidacies1752703candidacies
candidiases1552133candidiases
candidiasis1551443candidiasis
candidness1444773candidness
candied113816023candi_ed
candlers114214103candlers
candles104422343cand_les
candors104216763cand_ors
candours11408643candours
canellas10310563canellas
canid85526343can_id__
canines93724033can_ines
cannas84518403can__nas
cannibal1245203cannibal
cannibals1354453cannibals
cannings113710333cannings
cannulas1037583cannulas
canolas9313993can_olas
cantalas104013523cantalas
cantatas103410093cantatas
cantina93417253cantina_
canulas9312853can_ulas
canvas113813333can__vas
canzonas1935383canzonas
capias10318353ca_pi_as
capsidal1345623capsidal
capsids1239333capsid_s
carbides133111693carbides
cardia9916383cardi_a_
cardiac1278823cardi_ac
cardiacs1376923cardiacs
cardiae10713713cardi_ae
cardigan1245623cardigan
cardigans1345163cardigans
cardinal1139573cardinal
cardinals1248003cardinals
cardings123812643cardings
carditis11310233carditis
carinas93622413ca_rinas
caritas93316963ca_ritas
casitas93312043ca_sitas
cassias93514343cassi_as
cassinas103610643cassinas
caudices13337343caudices
cnida878953c_n_ida_
cnidae978143c_n_idae
confides14310573confides
conoidal1149013conoidal
conoids10813883conoid_s
corridas1177323corridas
cyanides14258003cyan_ides
cyanids13297933cyan_id_s
dandies94121443dandi_es
gadids95611823ga_did_s
ganoids939333ganoid_s
handicap1644933handicap
handicaps1744083handicaps
landings103110073landings
landsides11116743landsides
mandalas1139443mandalas
mandiocas1443943mandiocas
mandolas1139133mandolas
manias84029033man_i_as
manilas93915873man_ilas
mantids103113623mantid_s
nandina838913nandina_
nandins8312003nandi_ns
panadas103312213pan_adas
pandas95521963pan__das
pandies104224503pandi_es
pandits103914213pandi_ts
pandoras11310053pandoras
panduras1136953panduras
randies84225663randi_es
ranids75118703ran_id_s
sanddab1144923sand_dab
sanddabs1243903sand_dabs
scandia1038063scandi_a_
scandiums1443983scandiums
vandas103915993van__das
zenaidas18513663zenaidas

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.436409841.7
2DLD Change Limit1461621207.72018932.9
3Display Results1201200.0631904.8
 (SQL Overall)1786911208.21921741.2
 
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.