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

260 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
greasier929808(None) 
creasier103210191creasier
greaser83913081greas_er
brasier94516752br_asier
creakier14328332creakier
creamier12319062creamier
creaser94415732creas_er
dreamier11287292dreamier
drearier9297922drearier
dressier956862dressier
easier64218462__easier
freakier15246482freakier
gleamier1144912gleamier
grapier103712602gr_apier
grasper10389792gr_asper
grassier9349282grassier
grazier173611132gr_azier
grease75416232greas_e_
greased93812392greas_ed
greasers93410252greas_ers
greases84816712greas_es
greasiest10208562greasiest
greasily1236232greasily
greasing102811392greasing
greater84416492grea_ter
greedier1036082greedier
greenier938712greenier
grenadier1144092grenadier
queasier1734472queasier
readier83117422_readier
tressier847962tressier
uneasier836962uneasier
artsier768943ar_tsier
beadier103513913_beadier
beakier134012163_beakier
beamier113411943_beamier
blearier1037333blearier
brakier133812363br_akier
brasher124515243br_asher
brashier13389933br_ashier
brasiers103710513br_asiers
brassier103310533brassier
brazier183911473br_azier
breacher153011503breacher
breaker133912923brea_ker
breasted1138823breasted
breather133610593breather
breathier1435383breathier
breezier1934533breezier
brevier1237763bre_vier
cheesier1335963cheesier
crasher124616163cr_asher
crasser94114333cr_asser
crazier183610743cr_azier
creamer113714093crea_mer
crease85519573creas_e_
creased104315583creas_ed
creasers103612833creas_ers
creases94020963creas_es
creasiest11229943creasiest
creasing113314443creasing
creepier1236253creepier
crepier1139743cre_pier
croakier14436263croakier
crosier94116573cr_osier
degreaser1144333degreas_er
dreamer104110843drea_mer
drearies92313413drearies
dreggier1193553dreggier
dresser83611953dre_sser
drossier956313drossier
drowsier1284903drowsier
easies64126633__easies
easter65027983__easter
eraser64216333er_as_er
feaster10812983_feaster
fresher132612643fre_sher
frettier1156593frettier
frowsier1444893frowsier
gamier93617933g__amier
gasalier936443gasalier
gasher104320373g__asher
gasper94515543g__asper
gasser75017773g__asser
gassier83812573g_assier
gaster75027353g__aster
geekier12286393g_eekier
gemmier12337383g_emmier
germier10309543g_ermier
geyser1036513g_eys_er
glacier103911293g_lacier
gladier93810993g_ladier
glarier84112203g_larier
glassier9289083glassier
glazier17409353g_lazier
gleamer10328513glea_mer
gleaner8379773glea_ner
gleetier934913gleetier
glossier9358203glossier
goosier83512563g_oosier
gorsier83811073g_orsier
grabber12389763gr_abber
grabbier13316653grabbier
grader84919693gr_a_der
grafter114211153gr_after
grainer83714063gr_ainer
grainier9218903grainier
grander93315873gr_ander
granger93514213gr_anger
granter84117133gr_anter
grasped11409063gr_asped
graspers11338403gr_aspers
grassed93812793gr_assed
grasses84117343gr_asses
grater74625443gr_a_ter
graver105018593gr_a_ver
gravies11314093gr_avies
grayer106014543gr_a_yer
grazer164815763gr_a_zer
graziers18387123gr_aziers
greasiness1156543greasiness
greasy10419463greas__y
greaten83610643grea_ten
greave104611493grea_ve_
greaved12408913grea_ved
greaves113311443grea_ves
greener83111713gre_ener
greenie8310123greenie_
greenies9312673greenies
greeter82812673gre_eter
greisen856503greis_en
gremmie1264383gremmie_
gremmies1355993gremmies
grenadiers1242593grenadiers
grewsomer1542493grewsomer
greyer104510093gre__yer
grimier103210433gr_imier
gripier103210323gr_ipier
grippier1355203grippier
grislier935793grislier
grister83915413gr_ister
grittier9316263grittier
groaner82510133groa_ner
grodier939673gr_odier
groggier1134343groggier
groovier1233793groovier
grosser84313143gr_osser
grottier9316673grottier
grouser84513693grous_er
groutier9297173groutier
growlier1234883growlier
grubbier13344753grubbier
gruffier1544703gruffier
grumpier1334803grumpier
grungier1034983grungier
guesser8166543gue_sser
gutsier8389823g_utsier
headier113212953_headier
heavier13429423_heavier
leadier83212723_leadier
leafier10329833_leafier
leakier114010993_leakier
learier73415663_learier
leaser65322673_leas_er
leavier10319993_leavier
mealier93015903_mealier
measlier1036013_measlier
meatier93214613_meatier
messier93412923_messier
newsier10147223_newsier
oleaster837263oleaster
peakier134411443_peakier
peatier94017233_peatier
pleaser93912343pleas_er
praiser93413943pr_aiser
preacher153211373preacher
preachier1646923preachier
prealter1048863prealter
preaver121011613prea_ver
preciser123411663preciser
premier113515633pre_mier
preppier1156643preppier
presager1138443presager
presider11410423pre_sider
presser93717623pre_sser
prester93519623pre_ster
prettier1069043prettier
prissier10157873prissier
prosier93817483pr_osier
queazier2642833queazier
racier85120973_r_acier
raiser66620103_r_aiser
rapier84019993_r_apier
raser55633413_r_as_er
rasher95024123_r_asher
rasper83917333_r_asper
raspier93110643_r_aspier
raster64731443_r_aster
reacher123718293_reacher
reader73628293_rea_der
readied93316623_readied
readies83324713_readies
realer63528593_rea_ler
realiser82512563_realiser
realizer172412113_realizer
realter73716313_realter
reamer84325213_rea_mer
reaper84223143_rea_per
rearer64928913_rea_rer
reasoner849343_reasoner
reassert8313673_reassert
reaver94524733_rea_ver
recamier1237603_recamier
reedier83815303_reedier
reefier102912553_reefier
reekier113111123_reekier
reifier103414523_reifier
relier65826183_re_lier
remaster10311473_remaster
rentier73618223_rentier
replier94214973_replier
resider84615803_re_sider
rester63832433_re_ster
reviser104114663_reviser
roaster74116663_roaster
rosier64221263_r_osier
seamier93114633_seamier
sleazier1735123sleazier
smearier1036953smearier
sneakier1245143sneakier
steadier937313steadier
steamier1048303steamier
streakier1334843streakier
streamier1155763streamier
sweatier1147033sweatier
tearier73815613_tearier
teaser65421523_teas_er
teensier835573teensier
threadier1354473threadier
trasher104416133tr_asher
trashier113210103tr_ashier
treaclier1144153treaclier
treader84113833trea_der
treadler936863treadler
treasure846753treasure
treasurer944253treasurer
treater74219833trea_ter
treaties8316983treaties
trendier937913trendier
tweakier1533143tweakier
unreadier1045013unreadier
urease64516993ureas_e_
ureases74416723ureas_es
vealier102712173_vealier
wearier103613283_wearier
weensier1134243weensier
wreaker143610043wrea_ker
wreather14268603wreather
wrester102812413wre_ster
yeastier1135393_yeastier

Search took 8 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.420425454.8
2DLD Change Limit1461622607.19020328.5
3Display Results2602600.1062452.8
 (SQL Overall)1786912607.71623158.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.