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

111 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
greenery1226592(None) 
greener83111711greener_
greened93111262greene_d
greenest9312622greenest
greenfly1554082greenfly
greenier938712greenier_
greenly11408192green_ly
greenway1543852greenway
greeny104811452green__y
greeter82812672greeter_
greeters92610112greeters
preener93114832preener_
preeners102712812preeners
reentry1038032_reentry
beanery1237563_beanery
breeder103210043breeder_
breeders11368893breeders
brewery15376963br_ewery
careener1039323careener_
careeners1138533careeners
creamery15385983creamery
creeper11339983creeper_
creepers12318633creepers
deanery1137613_deanery
fernery1335813_fernery
freeness11710443freeness
freezer19348523freezer_
freezers20307173freezers
gardener1037103gardener_
gardeners1136603gardeners
geezer16278013g_eezer_
geezers17286513g_eezers
genera71211713g__enera
gentry103410443g__entry
gleaner8379773gleaner_
gleaners9348073gleaners
grainer83714063grainer_
grainers93012073grainers
granary1157793gr_anary
grapery13457953gr_apery
greaser83913083greaser_
greasers93410253greasers
greater84416493greater_
greedier1036083greedier_
greedily1345183greedily
greedy11518853gr_e_edy
greegree1044483greegree
green65522143green___
greenbelt1243973greenbelt
greenbug1242633greenbug
greeneries1167073greeneries
greenhead1443163greenhead
greenheart1453173greenheart
greenhorn1343143greenhorn
greenie8310123green_ie
greenies9312673greenies
greeniest1039033greeniest
greening103112533greening
greenish1247073greenish
greenlet948513greenlet
greenlets1044703greenlets
greenlit945803greenlit
greenness1046793greenness
greens75716873green__s
greenth11116723green_th
greenths1295213greenths
greenways1643433greenways
greeted93111383greete_d
greyer104510093gr_eyer_
greyness1235243greyness
griever1136033griever_
grievers1255473grievers
grillery12355503grillery
grindery13255513grindery
grinner8329233grinner_
grinners9288043grinners
groaner82510133groaner_
groaners9248503groaners
grocery13336763gr_ocery
groggery1433513groggery
grueler837023grueler_
gruelers936173gruelers
gunnery11376373g_unnery
hennery1335303_hennery
keener104012843_keener_
keeners113610783_keeners
ornery938463or__nery
preened103214993preene_d
reefer93314363_reefer_
reefers103312593_reefers
reeker103715593_reeker_
reekers113613143_reekers
reeler63822573_reeler_
reelers73520273_reelers
reenjoy1743293_reenjoy
reenter73217793_reenter_
reenters82915303_reenters
refinery14447193_refinery
revery124014213_r_every
scenery1236563_scenery
screener1037573screener_
screeners1136733screeners
serenely1147623serenely
serener73415763serener_
sheeney13398933sheene_y
sweeney13387003sweene_y
teener64717503_teener_
teeners74415453_teeners
tweener10306833tweener_
tweeners11306243tweeners
venery123710663__venery

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621117.51619446.8
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.98522378.3
 
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.