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

87 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
redreamed134502(None) 
dreamed114310632__dreamed
recreated12412532recreated
redeemed1235592red_eemed
redheaded1545082redheaded
redream10107912redream__
redreams1195952redream_s
redreamt11127182redream_t
redressed1137772redressed
reframed1437852refr_amed
reteamed1138012re_teamed
retreaded1137052retreaded
retreated10312622retreated
undreamed1336972undreamed
bedraped1455813bedr_aped
bedroomed1543643bedroomed
bereaved1446403be_reaved
breamed124011593__breamed
creamed123913713__creamed
daydreamed1851303daydreamed
decreased1345453decreased
degreased1244713degreased
dreaded103612023__dreaded
dreamer104110843__dreamer
federated1438423federated
outdreamed1443383outdreamed
precreased1544413precreased
pretreated1347623pretreated
reamed94326123___reamed
rearmed103912823rear__med
rebreed104611073rebre__ed
recleaned1236583recleaned
recrated112918603recr_ated
recreate10313603recreate_
recreates11313363recreates
redamaged1443343redamaged
redated93120923red__ated
reddened1136423redde_ned
redeemer1145323red_eemer
redefeated1544883redefeated
redefied1368223red_efied
redemand1245923red_emand
redenied10511283red_enied
redhead1257053redhea__d
redialed10310793red_ialed
redirected1444773redirected
rednecked1743163rednecked
redrafted1435143redrafted
redrawer1235313redr_awer
redreaming1446443redreaming
redresser1056793redresser
redresses10410293redresses
redried93714893redr__ied
redrilled1145353redrilled
reerected1238613reerected
reframe1239393refr_ame_
reframes1338993refr_ames
refreshed1685613refreshed
regeared1039433re_geared
regraded113410763regr_aded
regrated102816333regr_ated
regreened1145553regreened
regreeted1136173regreeted
regressed1138113regressed
regretted1137233regretted
regroomed1344153regroomed
reheated122415003re_heated
rehemmed1634153re_hemmed
released9310243re_leased
renamed103114523re__named
repealed113211873re_pealed
repeated113117443re_peated
repleaded1336293repleaded
repressed12610103repressed
reread71715433re_rea__d
rerented92516163re_rented
resealed92713973re_sealed
reseated93220263re_seated
rethreaded1543273rethreaded
retraced111413023retr_aced
retread849003retrea__d
retreater9310203retreater
retrimmed1443673retrimmed
revealed123211213re_vealed
reweaved1535953re_weaved
screamed13277603_screamed
streamed11258903_streamed

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 Filter1786911486410.406440125.6
2DLD Change Limit148641876.78021923.5
3Display Results87870.0461891.3
 (SQL Overall)178691877.23224708.4
 
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.