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

268 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
forester1131367(None) 
foreseer1139011foreseer
forested12312461forested
foresters12312531foresters
arrester839252arrester
dopester1137252dopester
fester94723512f__ester
fomenter1339262fomenter
forecaster1586002forecaster
foregoer1237252foregoer
foresee10414332fores_ee
foreseen1139102foreseen
foreseers1237402foreseers
foresees11311642foresees
forest94926742forest__
forestal11410282forestal
forestay1448192forestay
forestry1446722forestry
forests104114952forest_s
foreswear1543512foreswear
forever1338952fore_ver
forfeiter1544172forfeiter
forgetter1345372forgetter
foster94322222fo__ster
fresher132612642f_resher
fretter103412752f_retter
honester1139712honester
jokester1934442jokester
modester1197482modester
molester1099372molester
prester93519622_prester
rester63832432__rester
wrester102812412_wrester
afforested1752653afforested
arrested939153arrested
arrestee849443arrestee
arresters948193arresters
arrestor847653arrestor
attester836503attester
bimester1236163bimester
boaster94616433bo_aster
bolster93713423bo_lster
booster94314553bo_oster
burster9310293bur_ster
caresser1038813caresser
chorister1487143chorister
coaster94219043co_aster
contester11311183contester
correcter1348103correcter
corseted11311473corseted
coster84331293co__ster
coveter122912063cove_ter
crested103416533_crested
deforested1543843deforested
detester9239683detester
diester83013683_diester
digester10258433digester
directer1137583directer
doomster1135843doomster
dopesters1237283dopesters
dorser74819183dor_s_er
dresser83611953_dresser
erecter93113393_erecter
ester54727713___ester
faster94625773f__aster
feaster10812983f_easter
feater95224053f__eater
fermenter1497543fermenter
ferreter1136543ferreter
festers104121393f__esters
fetter94120383f__etter
fibster12146533f_ibster
figeater1236953figeater
filister1137403filister
firestorm1444563firestorm
firewater1545213firewater
fleeter103210363f_leeter
flesher133610923f_lesher
floreated1346573floreated
fluorescer1583193fluorescer
fluster103913063f_luster
focuser12155783focus_er
foetor939563fo_e_tor
foisted113210603fo_isted
folksier1533533folksier
fomented1437803fomented
fomenters1437853fomenters
footer94320773fo__oter
footstep1363823footstep
forager114412563for_ager
forayer13368953for_ayer
forbearer1444513forbearer
forcer114917343for__cer
forebear1346383forebear
foreboder1545743foreboder
forebye1536353forebye_
forecasted1685103forecasted
forecasters1675003forecasters
foredate12310913foredate_
foredated1447683foredated
foredates13310053foredates
foredoes12310803foredoes
forefather1943573forefather
forefeel14105513forefeel
forefeet14129393forefeet
foregather1743663foregather
foregoers1345953foregoers
foregoes1239523foregoes
foreigner1344663foreigner
foreknew1843733foreknew
foreleg1137743fore_leg
foremen12412923fore_men
foremother1843483foremother
fores85847103fores___
foresaid1247803foresaid
foresail1147823foresail
foresaw1377133fores_aw
foresheet1549233foresheet
foreshore15118213foreshore
foreshow1785893foreshow
foreside12310303foreside
foresides1339703foresides
foreskin1547023foreskin
forespeak1843473forespeak
forestage1346973forestage
forestages1446733forestages
forestall1246913forestall
forestaller1453253forestaller
forestays1546623forestays
forestial1247233forestial
foresting13311363foresting
forestries1348553forestries
foreswears1643223foreswears
foreswore15117403foreswore
foresworn15126073foresworn
foretaste1295863foretaste_
foretasted1484753foretasted
foretastes1375593foretastes
foretell1146123fore_tell
foretop12117893fore_top
forevers1438173fore_vers
forfeited1643793forfeited
forfeiters1643783forfeiters
forgather1643663forgather
forger104820773for__ger
forgetters1444163forgetters
forgiver1534183forgiver
forgoer1137693for_goer
forker134717903for__ker
forkier144311593for_kier
formate123115093formate_
formates132814293formates
formatter1445463formatter
former114221403for__mer
forrader1236153forrader
forsaker1545103forsaker
forswear1443293for_swear
forte86131463for__te_
fortes95327183for__tes
fosters104220103fo__sters
fouette1038213fouette_
fouettes1137883fouettes
foveate1338363foveate_
foveated1536293foveated
frater94520593f_r_ater
freer86021243f_re__er
freezer19348523f_reezer
frescoer1345983f_rescoer
freshed143312593f_reshed
freshen133010883f_reshen
freshes133515823f_reshes
freshet133416643f_reshet
fresnel1035893f_resnel
fretted113411853f_retted
fretters113410303f_retters
frettier1156593f_rettier
frisker14389273f_risker
fritter103912773f_ritter
fronter103611583f_ronter
frosted113211873f_rosted
frostier1148163f_rostier
frowsier1444893frowsier
frowsted1534313frowsted
frowstier1553143frowstier
fruiter10309683f_ruiter
gamester1137323gamester
gorsier83811073gor_sier
greater84416493_greater
greeter82812673_greeter
grister83915413_grister
harvester1544333harvester
hoister103714203ho_ister
holster103512213ho_lster
hoopster1335543hoopster
horsier103013243hor_sier
horste94817413hor_ste_
horstes104516113hor_stes
infester11239433infester
jester134319153__jester
jokesters2044443jokesters
jouster143311043jo_uster
keester11319913_keester
kiester11329973_kiester
lobster9288853lo_bster
lodestar944413lodestar
mobster11299213mo_bster
moister94015373mo_ister
molested11178243molested
molesters1198873molesters
monoester1146453monoester
monster93214603mo_nster
moreover1344863moreover
nester64124183__nester
oersted839553_oersted
oldster896573_oldster
oleaster837263_oleaster
orbiter937853_orbiter
orienter838313_orienter
ouster64223733_o_uster
oyster94111703_o_yster
pester84827593__pester
polestar1047113polestar
pollster1037103pollster
polyester1445353polyester
porter84224413por__ter
poster84129173po__ster
presser93717623_presser
presters103419003_presters
protester111510483protester
quester161410023_quester
raster64731443__raster
reforested1445383reforested
renter64527413__renter
rested74430783__rested
resters74130403__resters
rimester1037813rimester
roadster935463roadster
roaster74116663ro_aster
robuster1035663robuster
roister73516203ro_ister
rooster74415173ro_oster
roster64329083__roster
rouster73517083ro_uster
royster103110533ro_yster
semester1038903semester
songster935793songster
sorest65028003sorest__
sorter64425093sor__ter
tester64227153__tester
thresher1455823thresher
thruster1135793thruster
toaster74414463to_aster
tormenter1146703tormenter
treater74219833_treater
truster73114313_truster
tryster10369513_tryster
unforested1444803unforested
unrested91914513unrested
ureter6313203_ure_ter
wester94222893__wester
worser95117523wor_s_er
worsted1138013wor_sted
wrested113410933_wrested
wresters112711733_wresters
wrestler11306993_wrestler
yester93417983__yester
zester153617793__zester
zoster153715853zo__ster

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 Limit1461622687.98618302.3
3Display Results2682680.1062528.3
 (SQL Overall)1786912688.52820953.4
 
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.