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

135 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
redream1010791(None) 
redreams1195951redreams
redreamt11127181redreamt
dream85120392__dream
redear73515172red_ear
redeem9311532red_eem
redhead1257052redhead
redraw10269852redr_aw
redreamed1345022redreamed
redress82511872redress
redrew10309512redre_w
reread71715432re_read
reteam83214532re_team
retread849002retread
retreat7317532retreat
bedlam1149273bed_lam
bedroom1247083bedroom
bream95121813__bream
cereal8315833ce_real
cream95721353__cream
daydream1542343daydream
dram75832003__dr_am
dread74419023__dread
dreams94513983__dreams
dreamt94615713__dreamt
dreamy12509993__dreamy
drear65016903__drear
edema8610553_ed_ema
federal1148533federal
ferbam1339003fe_rbam
hereat93527413he_reat
oedema936573oed_ema
outdream1144713outdream
perea75026443pe_rea_
pretreat10311923pretreat
ream65841613___ream
reared75930013reare_d
rearer64928913reare_r
rearers74323563rearers
rearm75923573rear__m
rebred95816353rebre_d
rebreed104611073rebreed
recheat12415933recheat
reclean938523reclean
recreant10311283recreant
recreate10313603recreate
redan66125013red__an
redbay1238333red_bay
redbreast1243623redbreast
redcap1158493red_cap
redcoat10410883redcoat
redded94019553redde_d
redden83613623redde_n
reddens9259783reddens
redder83918143redde_r
redders93615343redders
reddest9311953reddest
rede55037673red_e__
redears82814453red_ears
reded74829123red_e_d
redeems1037163redeems
redefeat1246313redefeat
redefy13388763red_efy
redeny102712733red_eny
redes65139133red_e_s
redeye103811793red_eye
redheads1336173redheads
redia65524483red_ia_
rediae74221993red_iae
redial74923113red_ial
redias74523603red_ias
redirect11147993redirect
redleg839273redle_g
redlegs936823redlegs
redneck1445113redneck
redness82012443redness
redoes74623773redoe_s
redowa1038453redowa_
redowas1138393redowas
redraft11310573redraft
redrawn11245953redrawn
redraws11218473redraws
redreaming1446443redreaming
redried93714903redried
redries83721713redries
redrill857893redrill
redrive112410563redrive
redroot8312903redroot
redrove11249423redrove
redry94314363redr__y
redye94413473redye__
redyed114611243redye_d
redyes104214093redye_s
reerect92915883reerect
reframe1239393refr_ame
refresh1335453refresh
regear73512743re_gear
regreen8309043regreen
regreet83015953regreet
regress82711453regress
regret73723533regre_t
regrets83212923regrets
regrew10388563regre_w
regroom1077303regroom
rehear93713223re_hear
reheat94423943re_heat
rehem103815353re_he_m
repeal84718283re_peal
repeat85127213re_peat
replead10399013replead
repress92712683repress
reran57329103re_r_an
rereads81512293re_reads
rerent63832453re_rent
reseal64819643re_seal
reseat64131493re_seat
reseau64216213re_seau
respeak1335933respeak
respread1135433respread
reteams9339563re_teams
retear63115483re_tear
retem74221953re_te_m
rethread1245353rethread
retral64419743retr_al
retreads937823retreads
retreats8311413retreats
retrial7615553retrial
retrim83514883retr_im
reveal94115053re_veal
rewear93012003re_wear
rewrap11127533rewr_ap
ruderal837373ruderal
scream104814253_scream
stream84717293_stream
undreamt1156543undreamt

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.390458182.1
2DLD Change Limit1340271357.03019065.0
3Display Results1351350.0502700.0
 (SQL Overall)1786911357.47023921.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.