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

215 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
foresters1231253(None) 
foreseers1237401foreseers
forester11313671forester_
arresters948192arresters
dopesters1237282dopesters
festers104121392f__esters
fomenters1437852fomenters
forecasters1675002forecasters
foregoers1345952foregoers
foreseer1139012foreseer_
foresees11311642fores_ees
forestays1546622forestays
forested12312462foreste_d
forestry1446722forest_ry
forests104114952forest__s
foreswears1643222foreswears
forevers1438172fore_vers
forfeiters1643782forfeiters
forgetters1444162forgetters
fosters104220102fo__sters
fretters113410302f_retters
jokesters2044442jokesters
molesters1198872molesters
presters103419002_presters
resters74130402__resters
wresters112711732_wresters
arrestees946233arrestees
arrester839253arrester_
arrestors958033arrestors
attesters935803attesters
bimesters1336343bimesters
boasters103915663bo_asters
bolsters103712453bo_lsters
boosters104013443bo_osters
bursters1038983bur_sters
caressers1137443caressers
choristers1586103choristers
coasters104317333co_asters
contesters12410183contesters
costers94128333co__sters
coveters132411083cove_ters
detesters10298303detesters
diesters92513603_diesters
digesters11257883digesters
doomsters1236173doomsters
dopester1137253dopester_
dorsers83516303dor_s_ers
dressers9359863_dressers
erecters102611613_erecters
esters64627733___esters
feasters11511563f_easters
fermenters15116533fermenters
ferreters1246253ferreters
fester94723513f__ester_
fetters103517903f__etters
fibsters13126413f_ibsters
figeaters1345753figeaters
filisters1237003filisters
firestorm1444563firestorm
firestorms1543293firestorms
firewaters1644323firewaters
fleshers14339443f_leshers
fluorescers1692703fluorescers
flusters113811503f_lusters
focusers13134373focus_ers
foetors1039763fo_e_tors
fomenter1339263fomenter_
footers104618333fo__oters
footsteps1462863footsteps
foragers12349633for_agers
forayers14277273for_ayers
forbearers1543673forbearers
forcers124215713for__cers
forebears1446413forebears
foreboders1644173foreboders
forecaster1586003forecaster_
foredates13310053foredate_s
foredoes12310803foredoe_s
forefathers2053143forefathers
forefeels1593843forefeels
foregathers1843223foregathers
foregoer1237253foregoer_
foregoes1239523foregoe_s
foreigners1444143foreigners
forelegs1236613fore_legs
foremothers1953013foremothers
foresails1247153foresails
foresee10414333fores_e_e
foreseen1139103fores_een
foresheet1549233foresheet
foresheets1654603foresheets
foreshore15118213foreshore
foreshores16107403foreshores
foreshows1875973foreshows
foresides1339703foresides
foreskins1647043foreskins
forespeak1843473forespeak
forespeaks1943123forespeaks
forest94926743forest___
forestage1346973forestage
forestages1446733forestages
forestal11410283forest_al
forestall1246913forestall
forestallers1552503forestallers
forestalls1345803forestalls
forestay1448193forest_ay
forestial1247233forestial
foresting13311363foresting
forestries1348553forestries
foreswear1543513foreswear
foreswore15117403foreswore
foresworn15126073foresworn
foretastes1375593foretaste_s
foretell1146123fore_tell
foretells1245633fore_tells
foretops13137483fore_tops
forever1338953fore_ver_
forfeiter1544173forfeiter_
forgathers1743553forgathers
forgers115218183for__gers
forgetter1345373forgetter_
forgivers1643713forgivers
forgoers1236413for_goers
forkers144615783for__kers
formates132814293formate_s
formatters1544573formatters
formers128217953for__mers
forsakers1644653forsakers
forswears1543243for_swears
fortes95327183for__te_s
foster94322223fo__ster_
fouettes1137883fouette_s
fraters103517213f_r_aters
freers94717303f_re__ers
freezers20307173f_reezers
frescoers1454563f_rescoers
freshens14298313f_reshens
fresher132612643f_resher_
freshes133515823f_reshe_s
freshets14298673f_reshets
fresnels1135233f_resnels
fretter103412753f_retter_
friskers15337373f_riskers
fritters113810783f_ritters
frosteds12305653f_rosteds
fruiters11328183f_ruiters
gamesters1236733gamesters
greeters92610113_greeters
gristers94013403_gristers
harvesters1644143harvesters
hoisters113513483ho_isters
holsters113211943ho_lsters
honester1139713honester_
hoopsters1445693hoopsters
horstes104516113hor_ste_s
infesters12237713infesters
jesters144118193__jesters
jokester1934443jokester_
jousters153210423jo_usters
keesters12319593_keesters
kiesters123310153_kiesters
lobsters10268743lo_bsters
lodestars1044413lodestars
mobsters12359063mo_bsters
modester1197483modester_
molester1099373molester_
monoesters1245993monoesters
monsters103314553mo_nsters
nesters74422793__nesters
oersteds934373_oersteds
oldsters996733_oldsters
oleasters936733_oleasters
orbiters1036593_orbiters
orienters937613_orienters
ousters74122793_o_usters
oysters103411693_o_ysters
pesters93827093__pesters
polestars1157283polestars
pollsters1137173pollsters
polyesters1545233polyesters
porters93722703por__ters
posters93928013po__sters
pressers103215023_pressers
prester93519623_prester_
protesters12169383protesters
questers17168763_questers
rasters74629023__rasters
renters74224813__renters
rester63832433__rester_
rimesters1137483rimesters
roadsters1035103roadsters
roasters83615933ro_asters
roisters83615553ro_isters
roosters83514663ro_osters
rosters73727543__rosters
rousters84315683ro_usters
roysters113610533ro_ysters
semesters1139123semesters
songsters1046113songsters
sorters74221133sor__ters
testers74124543__testers
threshers1545423threshers
thrusters1245333thrusters
toasters83912723to_asters
tormenters1245823tormenters
treaters83615843_treaters
trusters83112263_trusters
trysters11298373_trysters
ureters7311823_ure_ters
westers105221963__westers
worsteds1234483wor_steds
wrester102812413_wrester_
wrestlers12306103_wrestlers
zesters163517293__zesters
zosters163015413zo__sters

Search took 10 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 Filter1786911486410.440406115.9
2DLD Change Limit1486412158.67017144.3
3Display Results2152150.0932311.8
 (SQL Overall)1786912159.20319416.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.