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

270 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
grassier934928(None) 
brassier103310531brassier
gassier83812571g_assier
glassier9289081glassier
brashier13389932brashier
brasier94516752bra_sier
brassie93411522brassie_
brassiere11365382brassiere
brassies103613532brassies
classier10359082classier
crasser94114342crass_er
dressier956862dressier
drossier956312drossier
gasser75017772g_ass_er
glassie8329492glassie_
glassies94012272glassies
glossier9358202glossier
grabbier13316652grabbier
grainier9218902grainier
grapier103712602gra_pier
grasper10389792gra_sper
grassed93812792grass_ed
grasses84117342grass_es
grassiest10309512grassiest
grassily1236432grassily
grassing103311972grassing
grazier173611132gra_zier
greasier9298082greasier
grislier935792grislier
grosser84313142gross_er
massier93615222_massier
prissier10157872prissier
raspier93110642_raspier
sassier73413232_sassier
trashier113210102trashier
tressier847962tressier
amasser9418733amass_er
artsier768943ar_tsier
ashier94714833__ashier
blastier10249493blastier
bossier93712423_bossier
braggier12136453braggier
brainier102510233brainier
brakier133812363bra_kier
brannier10218933brannier
brasher124515243bra_sher
brasiers103710513bra_siers
brassed103612373brass_ed
brasses93818353brass_es
brassica1244873brassica
brassieres12274383brassieres
brassiest11369713brassiest
brassily1336623brassily
brassing112612303brassing
brassish1346433brassish
brattier1047663brattier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473bra_zier
brushier13306973brushier
cashier123713323_cashier
classer93614613class_er
crabbier14326803crabbier
craftier1376193craftier
craggier12116063craggier
crampier14288903crampier
crankier14339163crankier
crappier14288133crappier
crasher124616163cra_sher
crawlier13216873crawlier
crazier183610743cra_zier
creasier103210193creasier
crispier12297253crispier
crosier94116573cr_osier
crosser95015463cross_er
crustier10259533crustier
cuirassier1251263cuirassier
dashier114311183_dashier
dassie74615573_dassie_
dassies84418663_dassies
dossier83711693_dossier
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
dragster1034623dragster
drawlier12225253drawlier
dresser83611953dress_er
drowsier1284903drowsier
easier64218463_ea_sier
eraser64216333era_s_er
flashier1437103flashier
flossier11326973flossier
frasses104314513frass_es
friskier1535193friskier
frostier1148163frostier
frowsier1444893frowsier
fussier103610673_fussier
gabbier12379633g_abbier
gagster9317633g_agster
gambier124711973g_ambier
gamier93617933g_a_mier
gammier123711193g_ammier
gappier12369843g_appier
gasalier936443g_asalier
gaselier946963g_aselier
gasher104320373g_a_sher
gasifier1236273g_asifier
gasolier935833g_asolier
gasper94515543g_a_sper
gassed85217633g_ass_ed
gassers84714633g_ass_ers
gasses75724783g_ass_es
gassiest93212523g_assiest
gassily1137813g_assily
gassing94216333g_assing
gaster75027353g_a_ster
gaudier938453g_audier
gauzier1735633g_auzier
gawkier15326523g_awkier
gawsie1038463g_awsie_
ghastlier1342893ghastlier
ghostier1235383ghostier
glacier103911293gla_cier
gladier93810993gla_dier
gladlier1034343gladlier
glairier944833glairier
glarier84112203gla_rier
glassed93710433glass_ed
glasses84414273glass_es
glassiest10279243glassiest
glassily1235463glassily
glassine9329313glassine
glassines10278043glassines
glassing10329973glassing
glassmen1145393glassmen
glazier17409353gla_zier
glosser83410813gloss_er
glossies93311253glossies
gnarlier9255163gnarlier
gnattier934263gnattier
goosier83512563g_oosier
gorsier83811073g_orsier
gossiper1164203g_ossiper
grabber12389763gra_bber
grabbler13377693grabbler
grader84919693gra__der
grafter114211153gra_fter
grainer83714063gra_iner
grander93315873gra_nder
grandsir1044313grandsi_r
grandsire1145123grandsire
granger93514213gra_nger
grannie8310353grannie_
grannies9312613grannies
granter84117133gra_nter
grappler13336193grappler
grasped11409063gra_sped
graspers11338403gra_spers
grasping12348833grasping
grass66125203grass___
grassless1034303grassless
grasslike1443693grasslike
grassy10619093grass__y
grater74625443gra__ter
gratifier1345823gratifier
graver105018593gra__ver
gravies11314093gra_vies
grayer106014543gra__yer
grazer164815763gra__zer
graziers18387123gra_ziers
greaser83913083greas_er
greedier1036083greedier
greenier938713greenier
grimier103210433gr_imier
gripier103210323gr_ipier
grippier1355203grippier
grister83915413gr_ister
gristlier1044283gristlier
grittier9316263grittier
grodier939673gr_odier
groggier1134343groggier
groovier1233793groovier
grossed93812253gross_ed
grossers94410973gross_ers
grosses84517683gross_es
grossing103111063grossing
grottier9316673grottier
grouser84513693grous_er
groutier9297173groutier
growlier1234883growlier
grubbier13344753grubbier
gruffier1544703gruffier
grumpier1334803grumpier
grungier1034983grungier
grushie1135813grushie_
guesser8166543guess_er
gushier113110073g_ushier
gussie72910153g_ussie_
gussied9267193g_ussied
gussies82813303g_ussies
gustier83813863g_ustier
gutsier8389823g_utsier
harasser1137043harass_er
hastier103916623_hastier
hissier103410503_hissier
lassie64917743_lassie_
lassies74420103_lassies
lassoer7379383_lassoer
marshier1337593marshier
measlier1036013measlier
messier93412923_messier
mossier94413813_mossier
mussier93314363_mussier
nastier74115293_nastier
orangier947713orangier
passer84721033_pass_er
pastier94320383_pastier
plashier1337613plashier
praiser93413943prais_er
presser93717623press_er
prissies101712003prissies
prosier93817483pr_osier
prossie91812953prossie_
prossies101515223prossies
pussier93711993_pussier
racier85120973_ra_cier
rainier71614263_rainier
raiser66620103_rais_er
rallier73816273_rallier
rammier112811023_rammier
randier83618473_randier
rangier83714353_rangier
rapier84019993_ra_pier
raser55633413_ra_s_er
rasher95024123_ra_sher
rasper83917333_ra_sper
rassle63813203_rassle_
rassled83310453_rassled
rassles73513923_rassles
raster64731443_ra_ster
rattier74015593_rattier
riskier1138423_riskier
rosier64221263_r_osier
rushier103411973_rushier
rustier74416363_rustier
sassies74719263_sassies
sissier73711363_sissier
tarsier74119253_tarsier
tassie66017023_tassie_
tassies74918933_tassies
tastier711817093_tastier
toastier846893toastier
trampier12318243trampier
transfer1138433transfer
trasher104416133tra_sher
trasses74819323trass_es
trusser74010263truss_er
trustier8268683trustier
vastier103613203_vastier
washier133611153_washier
waspier12259053_waspier
wrasse9398773wrass_e_
wrasses103812593wrass_es
wrassle10357173wrassle_
wrassled12325383wrassled
wrassles11376713wrassles
wrathier1435903wrathier
wristier1136863wristier
wussier10408083_wussier
yeastier1135393yeastier

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.436409841.7
2DLD Change Limit1461622706.75021653.6
3Display Results2702700.1102454.5
 (SQL Overall)1786912707.29624491.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.