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

225 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
greenier93871(None) 
greedier1036081greedier
greener83111711green_er
greenie8310121greenie_
greenies9312671greenies
breezier1934532breezier
creepier1236252creepier
geekier12286392g_eekier
gleetier934912gleetier
grainier9218902grainier
greasier9298082greasier
greenbrier1352852greenbrier
greened93111262green_ed
greenery12265922green_ery
greeniest1039032greeniest
greening103112532greening
greenish1247082greenish
greenlet948512greenlet
greeter82812672gree_ter
preener93114832preen_er
reedier83815302_reedier
reefier102912552_reefier
reekier113111122_reekier
reenter73217792_reenter
sheenier11167422sheenier
teenier72611142_teenier
weenier103210802_weenier
beefier12329093_beefier
beerier93613023_beerier
brainier102510233brainier
brannier10218933brannier
brawnier13216723brawnier
breeder103210043bree_der
brevier1237763br_evier
brinier93613473br_inier
brownier13226913brownier
careener1039333careen_er
cheekier1735103cheekier
cheerier1348003cheerier
cheesier1335963cheesier
creakier14328333creakier
creamier12319063creamier
creasier103210193creasier
creeper11339983cree_per
creepie1137483creepie_
creepies1239613creepies
crepier1139743cr_epier
deedier93011593_deedier
denier74420693__denier
dernier83011943_dernier
dreamier11287293dreamier
drearier9297923drearier
dreggier1193553dreggier
dressier956863dressier
dweebier1442223dweebier
eelier64216463__eelier
eerier64320023__eerier
fennier10339253_fennier
fernier103110823_fernier
fleecier1334763fleecier
freakier15246483freakier
freebie1236043freebie_
freebies1337873freebies
freezer19348523free_zer
frettier1156593frettier
gardener1037103garden_er
gaselier946963gaselier
geezer16278013g_ee_zer
gemmier12337383g_emmier
gender83517933g__ender
genie66124923g__enie_
genies75324943g__enies
germier10309543g_ermier
ginnier8298983g_innier
gleamier1144913gleamier
gleaner8379773glean_er
goonier83612843g_oonier
grabbier13316653grabbier
grainer83714063grain_er
grander93315873gr_ander
granger93514213gr_anger
grannie8310353grannie_
grannies9312613grannies
granter84117133gr_anter
grapier103712603gr_apier
grassier9349283grassier
grazier173611133gr_azier
greaser83913083gr_easer
greater84416493gr_eater
greediest1147553greediest
greedily1345183greedily
greegree1044483greegree
greeing93613783gree_ing
green65522143green___
greenbelt1243973greenbelt
greenbriers1452263greenbriers
greenbug1242633greenbug
greeneries1167073greeneries
greenest9312623greenest
greenfield1552153greenfield
greenflies1443583greenflies
greenfly1554083greenfly
greenhead1443163greenhead
greenheart1453183greenheart
greenhorn1343143greenhorn
greenings11266663greenings
greenlets1044703greenlets
greenling1136753greenling
greenlit945803greenlit
greenly11408193green_ly
greenmailer1451813greenmailer
greenness1046793greenness
greens75716873green__s
greensick1642873greensick
greenth11116723green_th
greenths1295213greenths
greenway1543853greenway
greenwing1434693greenwing
greeny104811453green__y
greeted93111383gree_ted
greeters92610113gree_ters
greeting103112353greeting
gremmie1264383gremmie_
gremmies1355993gremmies
grenadier1144093grenadier
greyer104510093gr_e_yer
griever1136033grie_ver
grimier103210433gr_imier
grinder93312393gr_inder
grinner8329233gr_inner
gripier103210323gr_ipier
grippier1355203grippier
grislier935793grislier
grittier9316263grittier
groaner82510133groan_er
grodier939673gr_odier
groggier1134343groggier
groovier1233793groovier
grottier9316673grottier
grounder1047613grounder
groutier9297173groutier
growlier1234883growlier
grubbier13344753grubbier
grueler837023grue_ler
grueller935333grueller
gruffier1544703gruffier
grumpier1334803grumpier
grunger9389783gr_unger
grungier1034983grungier
grunter83110783gr_unter
keener104012843_keen_er
leerier73111503_leerier
needier84010623_needier
orienter838313orienter
ornerier846043ornerier
preemie11310563preemie_
preemies12512193preemies
preened103214993preen_ed
preeners102712813preen_ers
preening113115843preening
premier113515633pr_emier
preppier1156643preppier
presenter11311643presenter
pretender1246663pretender
prettier1069043prettier
preventer1438593preventer
queenlier1842123queenlier
rainier71614263_rainier
readier83117423_readier
recenter102715443_recenter
redenied10511283_redenied
redenies9615713_redenies
reechier1336673_reechier
reefer93314363_ree_fer
reeker103715593_ree_ker
reeler63822573_ree_ler
reenters82915303_reenters
refiner105316913_refiner
reifier103414523_reifier
reinter73116843_reinter
relier65826183_r_elier
render74024143_r_ender
reneger8299493_reneger
renewer10248693_renewer
renter64527413_r_enter
rentier73618223_rentier
repenter102813863_repenter
repiner94816903_repiner
replier94214973_replier
reuniter838323_reuniter
revenger1237303_revenger
revenuer1136893_revenuer
runnier74010113_runnier
screener1037573screen_er
seedier83513633_seedier
seepier92912013_seepier
serener73415763seren_er
sheenie10159493sheenie_
sheenies111411543sheenies
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
sneerier878103sneerier
sneezier1774333sneezier
speedier1146623speedier
spleenier1143863spleenier
steelier839193steelier
sweenies11148763sweenies
sweepier1355493sweepier
teener64717503_teen_er
teensier835573_teensier
trendier937913trendier
tressier847963tressier
tweedier1253623tweedier
tweener10306833tween_er
tweenies11146393tweenies
veinier10269583_veinier
vernier102711273_vernier
weedier113810623_weedier
weenie92612023_weenie_
weenies102915093_weenies
weensier1134243_weensier
weepier12319273_weepier
wennier10318603_wennier
wheezier2333343wheezier

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.436409841.7
2DLD Change Limit1461622257.70318974.7
3Display Results2252250.0932419.4
 (SQL Overall)1786912258.23221706.9
 
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.