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

492 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
forests10411495(None) 
forest94926741forest_
afforests1543732afforests
aorists74215832aorists
arrests73312682arrests
corsets94819802corsets
crests85218702_crests
deforests1344372deforests
fests85828042f__ests
firsts95110922fir_sts
florets1039852flore_ts
florists1138812florists
foists95413982fo_ists
foments122912052foments
footrests12244502footrests
forecasts1445802forecasts
foreguts1245562foreguts
foremasts1445792foremasts
fores85847102fore__s
foresaw1377132foresaw
foresee10414332foresee
foresees11311642foresees
forestal11410282forestal
forestay1448192forestay
forestays1546622forestays
forested12312462forested
forester11313672forester
foresters12312532foresters
forestry1446722forestry
forfeits1445802forfeits
forgets113813792forgets
forints10411832forints
formats123113572formats
forts86034452for__ts
frets85523402f_re_ts
frosts94214622f_rosts
frowsts13426102frowsts
horsts95817512hor_sts
molests93311562molests
prests84021262_prests
reforests1245532reforests
rests54935872__rests
sorest65028002sorest_
unrests7229462unrests
worsets105512842worsets
worsts96014332wor_sts
wrests95313082_wrests
afforest1446343afforest_
afreets1037013afreets
airest63825263airest_
amorists10411333amorists
aorist64827873aorist_
armrests1055383armrests
arrest63722633arrest_
attests7278813attests
aurists74615783aurists
barest85327693barest_
behests1235953behests
berets85822523bere_ts
bests75932613__bests
boasts85017923bo_asts
bonesets1036843bonesets
bookrests1542623bookrests
boosts86115013bo_osts
boreas85421733bore_as
boreases10310253boreases
boreens9310403boreens
borers85122683bore_rs
bores76448253bore__s
borshts1266543borshts
borts76735453bor__ts
breasts939703_breasts
brents84717273_brents
burets84321263bure_ts
bursts85116243bur_sts
caress85720263cares_s
carets85330773care_ts
chests114916263_chests
coasts85719143co_asts
coerects1258543coerects
cohosts12398813cohosts
comets105823583come_ts
congests113510383congests
contests103413383contests
corers85231073core_rs
cores76361853core__s
cornets94820573cornets
corpses113913803corpses
corrects1259573corrects
corses84433463cor_ses
corset85636223corset_
corvets124715023corvets
cosets85824403cose_ts
cossets95014283cossets
costs77231143co__sts
coverts124813813coverts
covets114819643cove_ts
coyest11316053coyest_
cress75022833_cres_s
crest74632693_crest_
crusts84916543_crusts
curets84922343cure_ts
deforest1238793deforest_
detests83711743detests
devests114410473devests
digests93610613digests
directs102710263directs
direst75024243direst_
divests114510933divests
docents102810803docents
doest65829523do_est_
dorsels84412573dorsels
dorsers83516303dorsers
dourest8312943dourest_
dress65319833_dres_s
drest65530343_drest_
duress74712063dures_s
earnests837853earnests
egests74411253_egests
egress73310433egres_s
egrets72712243egre_ts
erects84116183_erects
facets116316653face_ts
fairest10412293fairest_
farers95924053fare_rs
fares85852873fare__s
farness102912203farnes_s
farts88336843far__ts
fasts86429683f__asts
feasts95116093f_easts
feats86432753f__eats
feists94915313f_eists
felts85324543f__elts
feres86038183fere__s
ferments13311473ferments
ferrets103111393ferrets
fess76529163f__es_s
fest74949443f__est_
fets75345943f__e_ts
fewest12311663fewest_
feyest12311403feyest_
fideists1245543fideists
fiesta938123f_iesta
fiestas1038433f_iestas
filets94718953file_ts
finest94321733finest_
firepots1346893firepots
firers94922683fire_rs
fires85740753fire__s
firmest1239273firmest_
first86226123fir_st_
fists85527543f__ists
fleets96915063f_leets
fliest94718433fliest_
floret9321123flore_t_
florist10314243florist_
floruits1145153floruits
focuses12159653focuses
foehns12204973fo_ehns
foes76543443fo_e__s
foetus958523fo_etus
fogeys13509263foge_ys
fogless1138193fogles_s
foist85730973fo_ist_
foleys123810463fole_ys
foment113718303foment_
fondest11312403fondest_
fonts86124753fo__nts
footrest11308853footrest_
foots85528283fo__ots
forages114217283forages
forams115115913for_ams
forays124813003for_ays
forbears1337073forbears
forbids13268263forbids
forbs105720803for__bs
forceps14466983forceps
forcers124215713forcers
forces114422133for_ces
fordless12289003fordles_s
fordoes11311963fordoes
fords95328183for__ds
fore78351473fore___
forearm1238703forearm
forearms1336603forearms
forebay1538133forebay
forebays1637263forebays
foreby1438633fore_by
forebye1536353forebye
forecast1349763forecast
foredate12310913foredate
foredates13310053foredates
foredid1238503foredid
foredo10510823fore_do
foredoes12310803foredoes
forego1038903fore_go
foregoes1239523foregoes
foregut1149163foregut
foreign1136833foreign
foreleg1137743foreleg
forelegs1236613forelegs
foreman12312363foreman
foremast1348613foremast
foremen12412923foremen
foremost1348583foremost
forensic1344943forensic
forensics1443833forensics
foreparts1445223foreparts
forepast1348043forepast
forepaw1595613forepaw
forepaws1695753forepaws
foreran10311793foreran
forerun1037653forerun
foreruns1146623foreruns
foresaid1247803foresaid
foresail1147823foresail
foresails1247153foresails
foreseen1139103foreseen
foreseer1139013foreseer
foreseers1237403foreseers
foresheets1654603foresheets
foreshow1785893foreshow
foreshows1875973foreshows
foreside12310303foreside
foresides1339703foresides
foresights1743753foresights
foreskin1547023foreskin
foreskins1647043foreskins
forestage1346973forestage
forestages1446733forestages
forestall1246913forestall
forestalls1345803forestalls
forestial1247233forestial
foresting13311363foresting
forestries1348553forestries
foretaste1295863foretaste
foretastes1375593foretastes
foretop12117893foretop
foretops13137483foretops
forever1338953forever
forevers1438173forevers
forfeit1339203forfeit_
forfends1544833forfends
forgat104018583forgat_
forgers115218183forgers
forges105024263for_ges
forget106326393forget_
forgoes11311353forgoes
forgot104318133forgot_
forint9325023forint_
forkers144615783forkers
forkiest153812303forkiest_
forkless15267433forkles_s
forks125324683for__ks
formals123312893formals
formants13269953formants
format113021353format_
formate123115093formate
formates132814293formates
formers128217953formers
formes114623713for_mes
formless13248083formles_s
formols12299413formols
forms105327053for__ms
formyls15235703formyls
fornent10312933fornent_
forrit91916623forrit_
fort76456443for__t_
forte86131463for__te
fortes95327183for_tes
forth116222673for__th
forties104323863forties
fortis95418613for_tis
fortress1136753fortres_s
forty114824273for__ty
forums114611843for_ums
forwent13310533forwent_
foss76431643fo__s_s
fossas94610703fo_ssas
fosses96022083fo_sses
fouette1038213fouette
fouettes1137883fouettes
foulest10313313foulest_
founts94313383fo_unts
foveas1238623fove_as
foveate1338363foveate
foxes156321093foxe__s
foxiest174310493foxiest_
foyers125413133foye_rs
foziest194110943foziest_
frass85321123f_ras_s
frats86829673f_r_ats
freaks134713063f_reaks
freers94717303f_reers
frees86131393f_re_es
freest95318283freest_
freres94716173f_reres
fresco1136473f_resco
frescos1236813f_rescos
fresh115012203f_res_h
freshes133515823f_reshes
freshets14298673f_reshets
fret75845043f_re_t_
fretty1249223f_retty
frises94124273f_rises
frisks13479263f_risks
frits86129103f_r_its
fritts94613193f_ritts
froes86126693froe__s
fronts94415793f_ronts
frost84727833f_rost_
frosty124710633f_rosty
frowst125512073frowst_
frowsty16464983frowsty
fruits94512493f_ruits
frusta937453f_rusta
fumets114311813fume_ts
funest94316863funest_
funfests14253563funfests
furless103210143furles_s
geests75912163_geests
gerents82612923gerents
gests66028813__gests
godets8410933gode_ts
gores65740373gore__s
gorgets94711783gorgets
goriest82218743goriest_
gorses74723293gor_ses
greats76318393_greats
greets75117423_greets
grists74716483_grists
guests74311203_guests
harvests14246173harvests
hests85829933__hests
hoists95516023ho_ists
holists104413963holists
honest94822423honest_
honesty13378053honesty
hornets104113553hornets
hornists11208833hornists
horses94729343hor_ses
horst85833513hor_st_
horste94817413hor_ste
horstes104516113hor_stes
hosts85526703ho__sts
hursts97213093hur_sts
imprests1246313imprests
incests92711383incests
infests10279793infests
ingests83210983ingests
invests10319683invests
jests125922453__jests
joists134711033jo_ists
joneses1438963joneses
jousts135011273jo_usts
jurists14409123jurists
karsts106012943kar_sts
korats105416063kor_ats
latests73910313latests
locusts9277933locusts
loess55714703lo_es_s
loments93413473loments
lores55045403lore__s
lorises73918593lorises
lowest93915593lowest_
lyrists1036963lyrists
merest84725113merest_
modest93818453modest_
modesty13476983modesty
molest85022743molest_
moments113113123moments
monists93614783monists
morass84614503moras_s
mordents1138813mordents
moreens939963moreens
morels84820013more_ls
mores76249643more__s
morsels94112653morsels
morts75533563mor__ts
mostests1036833mostests
mosts76028543mo__sts
motets84216193mote_ts
nests55728003__nests
noesis6311443no_esis
nonets64118703none_ts
oasts56529183_o_asts
obtests9136233obtests
odists749853_odists
offsets1333503offsets
oftest91212003oftest_
ogress7529503ogres_s
onsets64013543_onsets
oocysts1243923oocysts
orbits84211443_orbits
oreads73915773_oreads
ores46056683_ore__s
orgeats838353_orgeats
orients7311583_orients
orts46538333_or__ts
ousts55225703_o_usts
parents93418123parents
pareses94718883pareses
paresis93315093paresis
pests75933273__pests
podesta1036763podesta
podestas1146853podestas
poets76024443po_e_ts
poorest9312773poorest_
pores75849033pore__s
porisms113713453porisms
portents103512823portents
ports75934593por__ts
possets94212773possets
posts75228783po__sts
presets94216423_presets
press75425953_pres_s
prest75736353_prest_
presto84216203_presto
prestos93716083_prestos
priests93810863priests
protests10310493protests
purest84021933purest_
purists94014073purists
quests153310353_quests
rarest65725483rarest_
reests64618893_reests
reforest1139963reforest_
renests74014213renests
rents55935183__rents
rerents73319423rerents
resets65427613__resets
resits64725563__resits
rest46459843__rest_
retests73813853retests
rets45352563__re_ts
revests104413733revests
roasts64915413ro_asts
rodents8611543rodents
roosts64916323ro_osts
rosets65819953rose_ts
rousts617016723ro_usts
rusts55026993__rusts
serest64831613serest_
sorbents10279133sorbents
sorbets93012513sorbets
sorels63921163sore_ls
sores55454283sore__s
soroses73117483soroses
sorosis72611973sorosis
sorts54536663sor__ts
sourest7515713sourest_
streets73312613streets
stress66616673stres_s
surest65026763surest_
tests56530193__tests
threats104311673threats
thrusts10226523thrusts
toasts65914993to_asts
toreros7311343toreros
tores55352673tore__s
torments10310453torments
torrents838143torrents
torses64727953tor_ses
torsks10549123tor_sks
torsos64815733tor_sos
torts56138123tor__ts
tourists838313tourists
treats64821693_treats
tress55423163_tres_s
trets55928023_tre_ts
trusts64714433_trusts
trysts9448793_trysts
unrest62918853unrest_
verists103613673verists
versets103913103versets
versts93914733ver_sts
vests85325983__vests
volosts1036563volosts
votress1035483votres_s
wests85727003__wests
worrits10258683worrits
worsens104610263worsens
worses95522953wor_ses
worset96726583worset_
worst86330133wor_st_
worts88631183wor__ts
wrest84925433_wrest_
wrists95415643_wrists
wursts95211163wur_sts
yarest95018913yarest_
yores85031323yore__s
zests145419743__zests

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274926.50020619.5
3Display Results4924920.1732843.9
 (SQL Overall)1786914927.07925242.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.