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

274 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
frostier114816(None) 
frontier1147311frontier
frowstier1553141frowstier
crosier94116572cros_ier
crustier10259532crustier
drossier956312drossier
feistier1136192feistier
floatier1136982floatier
flossier11326972flossier
footier104115112f_ootier
foster94322222f_ost_er
frettier1156592frettier
friskier1535192friskier
froggier1354642froggier
fronter103611582front_er
frontiers1254992frontiers
frosted113211872frost_ed
frostiest1239212frostiest
frostily1436692frostily
frosting12311182frosting
frother133110152fro_ther
frothier1435952frothier
frouzier2043702frouzier
frowsier1444892frowsier
frowzier2343312frowzier
fruitier1136592fruitier
fustier104213932f_ustier
ghostier1235382ghostier
grottier9316672grottier
groutier9297172groutier
prosier93817482pros_ier
prostie91617742prostie_
prosties101421192prosties
rootier74915392_rootier
rosier64221262_ros_ier
roster64329082_rost_er
rustier74416362_rustier
troutier8277152troutier
trustier8268682trustier
wristier1136862wristier
artier63419733ar__tier
artsier768943arts_ier
blastier10249493blastier
blottier10336413blottier
booster94314553boost_er
boskier13309173_boskier
bossier93712423_bossier
brashier13389933brashier
brasier94516753bras_ier
brassier103310533brassier
brattier1047663brattier
bristlier1144313bristlier
bronzier1935633bronzier
broodier1157433broodier
broomier1236873broomier
brother123311333bro_ther
brownier13226913brownier
brushier13306973brushier
bustier93916153_bustier
chestier1387423chestier
cosier84423753_cos_ier
coster84331293_cost_er
costlier1038523_costlier
cottier93814173_cottier
craftier1376193craftier
crispier12297253crispier
croakier14436263croakier
crofter12299573croft_er
crosiers103312063cros_iers
crosser95015463cros_ser
crosstie1046933crosstie_
crosstied1245193crosstied
crossties1139013crossties
crostini1038293crostini
crostino1038883crostino
croupier1246883croupier
crozier18369933cro_zier
defroster1343893defrost_er
dossier83711693_dossier
dotier73917033_do_tier
dottier83910923_dottier
draftier1285263draftier
dressier956863dressier
driftier1275123driftier
droolier936073droolier
droopier1145573droopier
droskies13186343droskies
drouthier1343033drouthier
drowsier1284903drowsier
dustier83814133_dustier
faster94625773f_ast_er
fattier103513463f_attier
faultier1135283faultier
feaster10812983feast_er
fester94723513f_est_er
fibster12146533fibst_er
fishier13359853f_ishier
flashier1437103flashier
fleshier1435603fleshier
flintier1136393flintier
flirtier1144893flirtier
floater104413353float_er
flockier1745343flockier
floppier1554633floppier
flosser10339693flos_ser
flossie10337443flossie_
flossies112810123flossies
flouter104311343flout_er
fluster103913063flust_er
flutier103011553f_lutier
flytier13356503f_lytier
foamier12339003f_oamier
foggier12349913f_oggier
folkier14359043f_olkier
footer94320773f_oot_er
footie94718143f_ootie_
footies103721543f_ooties
footler104011873f_ootler
footsie1047653footsie_
footsies1139643footsies
forester11313673forest_er
forkier144311593f_orkier
forsaker1545103forsaker
forties104323863f_orties
fosterer11239523f_osterer
fosters104220103f_ost_ers
foxier163910033f_o_xier
fozier183710663f_o_zier
frater94520593fr_at_er
freakier15246483freakier
frescoer1345983frescoer
fresher132612643fres_her
fretter103412753fr_etter
frier85225843fr___ier
frillier1136513frillier
fringier1236553fringier
frisker14389273fris_ker
fritter103912773fr_itter
frizzier19284813frizzier
fronted114011273front_ed
frontes104214163front_es
fronting12310443fronting
frontlet1147653frontlet
frontmen1344423frontmen
frost84727833frost___
frostbit1344443frostbit
frostbite1443413frostbite
frostbites1542993frostbites
frosteds12305653frosteds
frostfish1842623frostfish
frostiness1336563frostiness
frostings1335733frostings
frostless1235743frostless
frostline1245883frostline
frostlines1345193frostlines
frostnip1342413frostnip
frostnips1441933frostnips
frosts94214623frost__s
frostwork1943493frostwork
frosty124710633frost__y
frothed14288783fro_thed
frothers14279813fro_thers
frotteur1142503frotteur
frowner13429683fro_wner
frowsted1534313frowst_ed
frowstiest1643083frowstiest
frowsting1634683frowsting
fruiter10309683fruit_er
frumpier1534173frumpier
fubsier12367763fubs_ier
fussier103610673f_ussier
ghostlier1343343ghostlier
glossier9358203glossier
goosier83512563goos_ier
gorsier83811073gors_ier
goutier82612353_goutier
grassier9349283grassier
grislier935793grislier
grister83915413grist_er
gristlier1044283gristlier
grittier9316263grittier
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grosser84313143gros_ser
grouter84412523grout_er
growlier1234883growlier
growthier1642203growthier
gustier83813863_gustier
hastier103916623_hastier
hootier104915353_hootier
horsier103013243hors_ier
hosier94219613_hos_ier
hostler103411023_hostler
joltier14318493_joltier
jostler14288223_jostler
knottier12203983knottier
loftier1037763_loftier
lustier73813503_lustier
mistier93418713_mistier
mossier94413813_mossier
mustier94017963_mustier
nastier74115293_nastier
nosier63716323_nos_ier
osier53518013__os_ier
ostler63312193__ostler
pastier94320383_pastier
pestier94317403_pestier
plottier10327263plottier
poster84129173_post_er
postie84123963_postie_
posties93128813_posties
pottier93516493_pottier
poutier93215323_poutier
prester93519623prest_er
prettier1069043prettier
prissier10157873prissier
profiter132710203profiter
proser84223463pros__er
prosper114012193pros_per
prossie91812953prossie_
prossies101515223prossies
raspier93110643_raspier
raster64731443_rast_er
rattier74015593_rattier
rentier73618223_rentier
rester63832433_rest_er
riskier1138423_riskier
roaster74116663_roast_er
rockier134911883_rockier
roilier7311523_roilier
roister73516203_roist_er
rookier114012383_rookier
roomier93812243_roomier
rooster74415173roost_er
rooter64926033_root_er
ropier84118803_ro_pier
rosters73727543_rost_ers
rotifer1036993_ro_tifer
rotter64325463_ro_tter
roupier9319493_roupier
rouster73517083_roust_er
router65025843_rout_er
rowdier11348593_rowdier
royster103110533_royst_er
runtier73512853_runtier
rushier103411973_rushier
rustler73512343_rustler
ruttier73412283_ruttier
sloshier1135283sloshier
snootier8278383snootier
snottier8217383snottier
snoutier8206973snoutier
sootier73916613_sootier
sportier102010053sportier
spottier10207313spottier
tastier711817093_tastier
testier74015643_testier
throatier1244553throatier
toastier846893toastier
trashier113210103trashier
tressier847963tressier
trotter73312253tro_tter
truster73114313trust_er
trusties82712853trusties
tryster10369513tryst_er
twistier1134813twistier
vastier103613203_vastier
wrester102812413wrest_er
wrestler11306993wrestler
yeastier1135393yeastier
zestier163010223_zestier
zootier163611173_zootier
zoster153715853_zost_er

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.420425454.8
2DLD Change Limit1461622747.55019359.2
3Display Results2742740.1062584.9
 (SQL Overall)1786912748.07622126.2
 
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.