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

122 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
green6552214(None) 
gree56641561gree_
greed75125691greed
greek105915941greek
greens75716871greens
greeny104811451greeny
grees65132471grees
greet65835321greet
preen75925051preen
treen55622751treen
agree65226032agree_
agreed84712502agreed
agrees74915322agrees
arene55329412arene
arpen74418042arpen
been65335782_been
boreen8314312boreen
bree67241262bree_
breed85526692breed
brees75632552brees
bren65629562br_en
careen84119492careen
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
dree56638322dree_
dreed75222842dreed
drees65628522drees
free75940182free_
freed95223542freed
freer86021242freer
frees86131392frees
gaen57329602g_aen
garden84215082garden
gee45359202g_ee_
geed65435502g_eed
geek95327022g_eek
gees55647882g_ees
geez146424862g_eez
gen45950512g__en
gene56237222g_ene
gerent73223102gerent
germen9612312germen
ghee85726112ghee_
ghees95215552ghees
gien56330022g_ien
given95915282given
glean65818202glean
glee55239062glee_
gleed75320572gleed
gleek105315102gleek
glees65027592glees
gleet65532342gleet
glen56027202g_len
gorhen1038892gorhen
graben9419722graben
grain65126252grain
gran56335012gr_an
graven104513522graven
great66034242great
greaten83610642greaten
grebe85114942grebe
grebes93813612grebes
greeds84314282greeds
greedy11518852greedy
greeing93613782greeing
greened93111262greened
greener83111712greener
greenie8310122greenie
greenly11408192greenly
greenth11116722greenth
greets75117422greets
grego7310522grego
greisen856502greisen
grew85620262gr_ew
grey85624042gr_ey
greyed114610602greyed
greyer104510092greyer
greyhen1443192greyhen
greys96614852greys
grief95319782grief
grin55733722gr_in
groan65618422groan
groin65521082groin
grown95317352grown
grue55825712grue_
gruel66014742gruel
grues65721962grues
gyrene10227242gyrene
keen84830412_keen
kreep114610412kreep
moreen8313342moreen
peen65938082_peen
pree67044732pree_
preed85128122preed
preens85020112preens
prees75937172prees
premen105017802premen
queen144312062queen
ree37974072_ree_
reed55549622_reed
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
regreen8309042regreen
rein46040892_rein
screen85216022screen
seen46943122_seen
sheen85023312sheen
skeen94817402skeen
teen45938202_teen
tree47745812tree_
treed65626732treed
treens65317872treens
trees55835762trees
tureen63312722tureen
tween84413742tween
ween75835462_ween
wheen115016052wheen
wren78221682wr_en

Search took 2 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.313570897.8
2DLD Change Limit538001221.39338621.7
3Display Results1221220.0304066.7
 (SQL Overall)1786911221.736102932.6
 
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.