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

349 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
afresh125550(None) 
fresh115012201_fresh
acres76327762acres_
afreet9315152afreet
airest63825262airest
apres75426402apres_
ares45871022a_res_
arrest63722632arrest
aures55137092aures_
fares85852872fares_
flesh115013742_flesh
frosh115713402_frosh
refresh1335452refresh
resh76523452__resh
thresh12276862thresh
aargh96314083aar_gh
aarrgh10786303aarrgh
abash106016513a_bash
abbes96723523abbes_
abbess10509773abbess
ables75935543ables_
ablest84721833ablest
ablush1147223ablush
abreast9311283abreast
abris75722603abris_
abyes105518533abyes_
access1037683access
aces67645093a_ces_
aches106132293aches_
acmes96020653acmes_
acnes75922623acnes_
acre67330773acre__
acred87126353acre_d
across8312643across
actress948533actress
address956103address
addrest958633addrest
adores74420723adores_
adzes155913803adzes_
aedes64625153aedes_
aeries64737783aeries_
aeriest73924053aeriest
afars85716513afars_
affect1448903affect
afforest1446343afforest
afield1035953afield
afire86215913afire__
afore85818603afore__
afraid1049723afraid
afreets1037013afreets
afrit8323173afr_it
afrits9311903afrits
after85719793afte_r
afters94717073afters
aftosa996573aftosa
agers65027853agers_
ages55844593a_ges_
aggress935593aggress
agree65226033agre_e
agreed84712503agreed
agrees74915323agrees
agues64919053agues_
aguish1059283aguish
aides65336613aides_
aired66032923aire_d
airer54927893aire_r
airers64922313airers
airiest74221013airiest
airless73712043airless
airns55521033airns_
airs46447433air_s_
airth85621023air_th
airths95414253airths
airts55626343airts_
akees96119243akees_
aleph10311393a_leph
ales47067103a_les_
alfredo1142483alfredo
alfresco1341533alfresco
almeh106214553alme_h
almehs11619493almehs
almes75126543almes_
aloes54933673aloes_
ambush1336113ambush
amies76837693amies_
ancress978613ancress
anes45255933a_nes_
ankush13114433ankush
antes56334323antes_
antres65021003antres_
aorist64827873aorist
apers76629133apers_
apes66047433a_pes_
apish105116633a_pish
apses76823913apses_
aptest82917513aptest
arbs66834733a_rbs_
arch98628443a_r_ch
arcs67834783a_rcs_
are37874573a_re__
area45843393a_re_a
areae55229743a_reae
areal55928733a_real
areas55935773a_reas
areca75618633a_reca
areic73219393a_reic
arena55323813a_rena
arene55329413a_rene
arepa75615563a_repa
arete56031353a_rete
arfs76029963a_rfs_
arise56436433a_rise
arks85936873a_rks_
arles56735743arles_
armrest9310163armrest
arms66137493a_rms_
arose55832083a_rose
arras55626133arras_
arrear6310253arrear
arrests73312683arrests
arris56824683arris_
ars37670933a_r_s_
arse46539273a_r_se
arses55733873a_rses
arts49650263a_rts_
artsy86012963a_rtsy
ash67944603a___sh
ashes86230613ashes_
aslosh966233aslosh
aspish114810333aspish
asses55629283asses_
assess65710463assess
ates45047923a_tes_
atresia7310233atresia
atresic9310003atresic
attest62618613attest
auras55932563auras_
aurei54821863aure_i
aureus65314883aureus
auris55331533auris_
aurist65027253aurist
avers85127313avers_
averse95811183averse
aves76142603a_ves_
awash116613163a_wash
awes76037553a_wes_
awless939263awless
axes117337853a_xes_
axles125219473axles_
ayes76543513a_yes_
azures15510183azures_
bares75457133bares_
barest85327693barest
barres84427553barres_
bores76448253bores_
brash106221563_brash
brush105917473_brush
byres104421383byres_
cadres94017933cadres_
cafes106426923caf_es_
cares77369183cares_
caress85720263caress
ceres75540013ceres_
cires74932913cires_
cores76361853cores_
crash109120013_crash
creesh11328333creesh
cress75022833_cress
crest74632693_crest
crush106815993_crush
cures75645433cures_
daftest11248943daftest
dares66146703dares_
direst75024243direst
dress65319833_dress
drest65530343_drest
dures65635923dures_
duress74712063duress
eagres74014573eagres_
egress73310433egress
enmesh1134893enmesh
eyres84921773eyres_
faces106439433faces_
fades94932863fades_
fairest10412293fairest
fairish1338993fairish
fakes126032483fakes_
fames105735923fames_
famish14311843famish
fanes84639893fanes_
farces115223323farces_
fards96629843fards_
fare76354463fare__
fared95842343fare_d
farer86733143fare_r
farers95924053farers
farles96025783farles_
farls85731113farls_
farms106324953farms_
farness102912203farness
faros85532023faros_
farts88336843farts_
fash107232293_f_ash
fates85139233fates_
faves115331423faves_
faxes155726653faxes_
fazes175527213fazes_
fees76450603_fees_
feh96136093_f_e_h
fehs106522383_f_ehs
feres86038183feres_
fes66551673_f_es_
fess76529163_f_ess
fest74949443_f_est
fires85740753fires_
fish106926283_f_ish
flash115716213_flash
fleshy15406283_fleshy
flush115116073_flush
foes76543443_foes_
fores85847103fores_
forest94926743forest
frass85321123_frass
freak125115243_freak
free75940183_fre_e
freed95223543_freed
freer86021243_freer
frees86131393_frees
freest95318283_freest
fremd115010323_fremd
frena85915273_frena
french143511213_french
frere85617723_frere
fresco1136473_fresco
freshed143312593_freshed
freshen133010883_freshen
fresher132612643_fresher
freshes133515823_freshes
freshet133416643_freshet
freshly16286833_freshly
fret75845043_fre_t
frets85523403_frets
fries85535603_fries_
frise85322453_frise
frisk125312373_frisk
frith115922033_frith
froes86126693_froes_
frost84727833_frost
froth115919283_froth
gaffes134811103gaffes_
garfish14179203garfish
garish104516923garish
girsh95310023gir_sh
gores65740373gores_
gursh94512333gur_sh
gyres94820323gyres_
haeres94017033haeres_
hares86255543hares_
harsh116418053har_sh
heres86245903heres_
heresy125011233heresy
hires86134343hires_
immesh1334113immesh
inmesh1134863inmesh
inrush936513inrush
ires45639283_ires_
lares54852633lares_
lores55045403lores_
lures56138533lures_
lyres85019963lyres_
madres93718183madres_
mares76457633mares_
marish114319053marish
marsh105320853mar_sh
matres84522233matres_
meres75143573meres_
merest84725113merest
mesh96823003__mesh
mires75640883mires_
mores76249643mores_
mures75937223mures_
nacres85614453nacres_
nares55544153nares_
oafish121311723oaf_ish
oarfish13158613oarfish
offish15137273offish
oftest91212003oftest
ogreish1134673ogreish
ogres65818633ogres_
ogress7529503ogress
ogrish1039263ogrish
onrush935343onrush
ores46056683_ores_
padres95016983padres_
pares77164483pares_
parflesh1643753parflesh
parish115022353parish
peres76246643peres_
perish114619063perish
pores75849033pores_
presa74319043_presa
prese75228383_prese
press75425953_press
prest75736353_prest
purest84021933purest
pyres105523883pyres_
qursh174110843qur_sh
qurush1835503qurush
raffish1658843raffish
rares55247443rares_
rarest65725483rarest
rash76039933__rash
res35565043__res_
rest46459843__rest
rush76628183__rush
sabres85520863sabres_
safes85226723saf_es_
safest95016603saf_est
seres55448893seres_
serest64831613serest
sheesh1237813sheesh
sires55945373sires_
sneesh945893sneesh
sores55454283sores_
sorest65028003sorest
stress66616673stress
surest65026763surest
tares57456563tares_
tarres64723043tarres_
thrash12258363thrash
thrush12257483thrush
tires55437493tires_
tores55352673tores_
trash86119763_trash
tres46542903_tres_
tress55423163_tress
tyres84725233tyres_
unmesh1145793unmesh
unrest62918853unrest
uprush1135783uprush
vires84529683vires_
wafers124316143wafers_
wares88250583wares_
wires86034913wires_
wrest84925433_wrest
yarest95018913yarest
yores85031323yores_
zaffres22324993zaffres_
zaires1539703zaires_

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127163495.23321539.5
3Display Results3493490.1103172.7
 (SQL Overall)1786913495.73631152.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.