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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
redds7461783(None) 
readds84111641readds
reads64835271reads
redd66323171redd_
redes65139121redes
redos65126761redos
reds56042861re_ds
reeds65430901reeds
rends65129951rends
rudds74811701rudds
adds67622452_adds
aedes64625142aedes
beads85429502beads
beds75937782be_ds
bends85628972bends
breads95419202breads
bredes94818472bredes
breeds94914882breeds
cedes84927322cedes
cedis84317082cedis
credos94612842credos
creds85418772cre_ds
creeds94714772creeds
deads75726912deads
deeds75423762deeds
dreads84115022dreads
eddo63411802_eddo
eddy93912092_eddy
edhs86212102_edhs
eds46638922_e_ds
elds56324852_elds
ends56528522_ends
feds85234312fe_ds
feeds94921142feeds
fends96324972fends
feods99516852feods
feuds95914882feuds
geds66730812ge_ds
gelds75118342gelds
greeds84314282greeds
heads95127112heads
heeds95420422heeds
herds96424682herds
leads66028492leads
lends65326252lends
leuds66214812leuds
meads85425322meads
meds75735362me_ds
meeds84920272meeds
melds84822382melds
mends84927692mends
neddy10479872neddy
needs65719632needs
nerds65719252nerds
odds68919922_odds
oreads73915772oreads
pedes85327282pedes
peds75835242pe_ds
pends85527192pends
rads56046602r_ads
raids65827512raids
rands65930452rands
read55942532read_
readd74617132readd
ready94821502ready
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
rebids94015522rebids
rebs65733562re_bs
rebus75721112rebus
recks115625132recks
recs65734182re_cs
red46755802re_d_
redan66125012redan
redans75421022redans
redbuds11144282redbuds
redded94019542redded
redden83613612redden
reddens9259782reddens
redder83918132redder
redders93615342redders
reddest9311952reddest
reddish1238032reddish
reddle83815912reddle
reddles93315772reddles
rede55037662re_de
reded74829112reded
redia65524482redia
redias74523602redias
redid74922392redid
redip87816962redip
redips93713842redips
redly94217192redly
redo56029362re_do
redoes74623752redoes
redon65424882redon
redons75222182redons
redox134714232redox
redry94314362redry
redub84212412redub
redubs9358382redubs
redux133811102redux
redye94413462redye
redyes104214082redyes
reed55549622reed_
reedy910020282reedy
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192re_es
refs75732242re_fs
reges65628782reges
regs55436572re_gs
reifs84819092reifs
reins56234562reins
reis45343232re_is
rems66237722re_ms
rend56136572rend_
rents55935182rents
repos74725792repos
repps95114342repps
reps65937952re_ps
res35565042re__s
resids74219152resids
resods74116302resods
rests54935872rests
rets45352562re_ts
revs75027052re_vs
reweds104412302reweds
rexes124526952rexes
rides66140812rides
rids56539542r_ids
rinds64826142rinds
roads66523612roads
rodes614039082rodes
rods56442062r_ods
roods65125282roods
rudd65917472rudd_
ruddy104511752ruddy
rynds9569972rynds
seeds64330062seeds
sends65528242sends
sudds75513592sudds
teddy10489492teddy
teds54932572te_ds
tends65425582tends
treads74817912treads
trends75513542trends
uredos73910622uredos
velds95615582velds
vends95520892vends
weds86628932we_ds
weeds95222212weeds
welds94719162welds
wends95822812wends
zeds145821802ze_ds

Search took 3 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 Filter178691538000.0802233637.5
2DLD Change Limit538001581.90628226.7
3Display Results1581580.0305266.7
 (SQL Overall)1786911582.01688636.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.