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

184 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
greed7512569(None) 
agreed84712501agreed
breed85526691breed
creed85727391creed
dreed75222841dreed
freed95223541freed
geed65435501g_eed
gleed75320571gleed
gree56641561gree_
greeds84314281greeds
greedy11518851greedy
greek105915941greek
green65522141green
grees65132471grees
greet65835321greet
greyed114610601greyed
preed85128121preed
reed55549621_reed
treed65626731treed
agree65226032agree_
agrees74915322agrees
arced88224162arced
armed86324432armed
bleed85019802bleed
bread85523112bread
bred75130972br_ed
brede85520502brede
bree67241262bree_
breeds94914882breeds
brees75632552brees
brewed125411872brewed
cered85227442cered
cred76530882cr_ed
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creped114115702creped
crewed125316562crewed
cried84624282cried
deed65340902_deed
degreed10258882degreed
dread74419022dread
dree56638322dree_
drees65628522drees
dried75321382dried
erred65915672erred
feed84538902_feed
free75940182free_
freer86021242freer
frees86131392frees
fremd115010322fremd
fried95322912fried
gaed66031512g_aed
gaged85522312gaged
gamed95126392gamed
gaped96123532gaped
garbed104815662garbed
garred85217402garred
gated75329772gated
gazed165520332gazed
ged57044532g__ed
gee45359202g_ee_
geek95327022g_eek
geeked124510162geeked
gees55647882g_ees
geez146424862g_eez
geld65828432g_eld
ghee85726112ghee_
ghees95215552ghees
gibed96215962gibed
gied64631982g_ied
girded93712492girded
girned84010512girned
girted83912872girted
gled65631142g_led
glede75517832glede
glee55239062glee_
gleeds84711622gleeds
gleek105315102gleek
glees65027592glees
gleet65532342gleet
gleyed11478152gleyed
glued75118362glued
gored75227082gored
gorged95016982gorged
gormed105013832gormed
graced105217902graced
grad66829862gr_ad
grade75126092grade
graded94919552graded
grand75122692grand
grated84523922grated
graved114818812graved
grayed115415642grayed
grazed174115912grazed
greased93812392greased
great66034242great
greaved12408912greaved
grebe85114942grebe
grebes93813612grebes
greened93111262greened
greens75716872greens
greeny104811452greeny
greeted93111382greeted
greets75117422greets
grego7310522grego
grew85620262gr_ew
grey85624042gr_ey
greyer104510092greyer
greys96614852greys
grid65829612gr_id
gride75223582gride
grided95117042grided
grief95319782grief
grieved1235282grieved
grimed104714092grimed
grind75917562grind
griped104114712griped
groped107515052groped
groved114413702groved
grue55825712grue_
gruel66014742gruel
grueled937132grueled
grues65721962grues
gurged95513362gurged
guyed1049892guyed
gybed125811022gybed
gyred105114092gyred
gyved13568742gyved
heed86437602_heed
ired55131872ir_ed
irked104510922irked
jeed125428502_jeed
jereed144012072jereed
kneed104612052kneed
kreep114610412kreep
meed74934702_meed
need54934152_need
orbed85516192orbed
oread64619602oread
peed76239182_peed
pree67044732pree_
preen75925052preen
prees75937172prees
premed114617762premed
preyed125313202preyed
pried84426862pried
pureed95017812pureed
read55942532_read
red46755802_r_ed
redd66323172_redd
rede55037672_rede
reded74829122_reded
ree37974072_ree_
reeds65430902_reeds
reedy910020292_reedy
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
refed93921922_refed
rend56136572_rend
rewed95425452_rewed
rued55729792_rued
screed95718932screed
seed55549482_seed
sered65737292sered
skeed105018982skeed
speed85526622speed
steed66024942steed
teed55439262_teed
tread64821702tread
tree47745812tree_
treen55622752treen
trees55835762trees
trend64817452trend
tried65026912tried
trued65117692trued
tweed94915092tweed
urged75316032urged
urped84615282urped
weed85637512_weed
wried95518562wried

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.343520965.0
2DLD Change Limit538001841.75030742.9
3Display Results1841840.0464000.0
 (SQL Overall)1786911842.13983539.5
 
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.