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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
redecide1212718(None) 
redecided1455121redecided
redecides1356561redecides
decide104116872__decide
medicide1447712medicide
redefied1368222redefied
redefine1238972redefine
redenied10511282redenied
redivide1355932redivide
regicide1245922regicide
bedecked1874573bedecked
bedside1156843bed_side
decade104216163__decade
decided124312423__decided
decider114213183__decider
decides114217653__decides
decile94619213__decile
decode104414743__decode
deicide1149403de_icide
deride84420033__deride
ecocide1246733_ecocide
excide1638423_e_xcide
feticide1447503feticide
genocide1245693genocide
medicides1556583medicides
medicine1349543medicine
predefine1546173predefine
raticide1148943raticide
reaccede1354363reaccede
recede95515533r__ecede
receive1239733rece_ive
recipe103414893r__ecipe
recite83625113r__ecite
recode93618713r__ecode
redacted12410243redacted
redeciding1544703redeciding
reded74829113rede__d_
redeemed1235593redeemed
redefies12710163redefies
redefined1445593redefined
redefines1347413redefines
redeliver1344363redeliver
redenies9615713redenies
redescribe1552863redescribe
redesign1045073redesign
redeye103811793rede__ye
rediae74221993red__iae
redid74922393red__id_
redivided1544253redivided
redivides1445683redivides
redline84218833red_line
rednecked1743163rednecked
redocked16206823redocked
redried93714893red_ried
redrive112410563red_rive
reduce9713253reduc__e
reduced11610323reduced_
reducible1444693reducible
reducing12310203reducing
reductive1547793reductive
reedlike1336213reedlike
refected142311663refected
refective1749113refective
regicides1345813regicides
reincite1089703reincite
rejected182710113rejected
rejectee17289623rejectee
rejective2148253rejective
remedied1237953remedied
renegade1045123renegade
reremice1246023reremice
resected112514743resected
resecure1047183resecure
reseize1639553rese_ize
reside74224933r__eside
reverie103615163reveri_e
seducive1444213seducive
selenide9158863selenide
undecided1445983undecided

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162796.95321021.4
3Display Results79790.0302633.3
 (SQL Overall)178691797.13925030.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.