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

390 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
almost8101443(None) 
accost101112262accost
aftmost1244972aftmost
alamos8415002alamos_
aldose7311092aldose
alist56136782al_ist
allot54933872allo_t
allots64019172allots
almas76629772almas_
almes75126542almes_
almond91410432almond
alms65834922alm_s_
aloft8423432al_oft
altoist7313392altoist
altos55822952altos_
ammos94815822ammos_
amort75832202a_mort
calmest11312342calmest
glost65422932gl_ost
inmost8411362inmost
lamest84722762lamest
lost47951492_l_ost
most66554202__most
palmist112814342palmist
upmost1068192upmost
utmost878482utmost
abbot9318453abbo_t
abbots1039283abbots
abelmosk1641203abelmosk
ableist9311773ableist
ablest84721833ablest
abmhos1334973abmhos_
abort76133583a_bort
abos67734413a_bos_
about75229083a_bout
abvolt11169833abvolt
accosts11107993accosts
acmes96020653acmes_
across8312643across
adios65822863adios_
adjust1447183adjust
admass957143admass
admit8319493adm_it
admits9411413admits
admixt1637333admixt
adopt81219743a_dopt
ados57633513a_dos_
adroit7518793adroit
adust64117453a_dust
aerosat7417183aerosat
afloat9315153afloat
afoot8420113a_foot
aftosa996573aftosa
ageist7315383ageist
aghast105711373aghast
agios65919863agios_
agist66325583a_gist
agmas85919873agmas_
ailment9314233ailment
aims67738183aim_s_
airest63825263airest
airpost939243airpost
alamo7418143alamo__
alamode1038153alamode
alans55636173alans_
alant55742293al_ant
alants67722023alants
alarmist1049123alarmist
alas46358123al_as_
albas75925393albas_
albeit8314343albeit
albs68628573al_bs_
albumose1272633albumose
alcove1178083alcove
aldol61212333aldo_l
aldols7109713aldols
aldoses8311203aldoses
alecs76620733alecs_
alefs87319663alefs_
alert54740653al_ert
alerts64418223alerts
ales47067103al_es_
alfas87219043alfas_
algas65624933algas_
algoid83011473algoid
algor6513053algo_r
algors7312553algors
alias55834603alias_
alifs86121263alifs_
alight103816863alight
aliment9316703aliment
alimony1236013alimony
alit46155693al__it
aliyos9349533aliyos_
aliyot93611713aliyot
alkoxy2033343alkoxy
allod64418383allo_d
allods73615083allods
allow85420663allo_w
allows94517683allows
alloy85519973allo_y
alloys94014563alloys
alls46740923al_ls_
alma66333023alm__a
almagest1146233almagest
almah106917253alm_ah
almahs118611613almahs
alme65832163alm__e
almeh106214553alm_eh
almehs11619493almehs
almner85710723almner
almonds10127953almonds
almondy13144483almondy
almoner949383almoner
almonry12104733almonry
almuce10348213almuce
almud84012183alm_ud
almude9399933almude
almuds9378773almuds
almug8429303alm_ug
almugs9396423almugs
aloe45540193al_o_e
aloes54933673al_oes
aloha8513613al_oha
aloin55227423al_oin
alone55732963al_one
along65419493al_ong
aloof83521573al_oof
aloud65018073al_oud
alow75328593al_o_w
alps65529243al_ps_
als36663023al__s_
also46423443al__so
alt36467963al___t
alto47831263alto__
altoists848753altoists
alts46639903al_ts_
alumroot1044893alumroot
alums75720603alums_
amas67746293a_mas_
amass77119683a_mass
ambit94223713a_mbit
ambos95321253ambos_
ament76036543a_ment
amidst94913233amidst
amis66445323a_mis_
amiss75823073a_miss
ammo85520133ammo__
ammono1047373ammono
amok10217403a_mo_k
amoks11413553a_moks
amole75724593a_mole
among85813303a_mong
amongst1045363a_mongst
amorist9317643a_morist
amosite9313163a_mosite
amount8414483a_mount
amour75014853a_mour
amps86230343a_mps_
amus65529613a_mus_
amuse75920833a_muse
anenst63514983anenst
angst6415493a_ngst
animist93815173animist
aorist64827873aorist
aport75432173a_port
apos65433823a_pos_
appose10411993appose
aptest82917513aptest
argosy1036423argosy
argot67728653argo_t
argots74116033argots
ariose64818723ariose
ariosi64313033ariosi
arioso64312403arioso
arkose104911343arkose
armet76739453arm_et
armets84918353armets
armlet84118193armlet
armor75118053armo_r
armors85017813armors
armory114211473armory
armour84411853armour
armpit10811093armpit
armrest9310163armrest
arms66137493arm_s_
arose55832083a_rose
arrest63722633arrest
artist64125543artist
arvos86015663arvos_
ascot76522513asco_t
ascots85312513ascots
askos95011773askos_
aslosh966233aslosh
assist6314603assist
assort64916383assort
atmas75721013atmas_
atomist92915763atomist
atoms76817563atoms_
attest62618613attest
august739203august
auldest839893auldest
aurist65027253aurist
autist64324943autist
autos56523323autos_
avast85519363a_vast
avos77227013a_vos_
avoset9315673a_voset
awlwort1356353awlwort
awmous1157713awmous
backmost1846633backmost
baldest102313533baldest
ballast9313993ballast
ballot84624093ballo_t
ballots94116033ballots
balmiest124110993balmiest
balms95723923balm_s_
bemist105216963bemist
blast76532573bl_ast
blest76431723bl_est
bloat75229923bl_oat
blot65842323bl_o_t
blots75626173bl_ots
bluest84016483bluest
boost75132473_boost
callose9313663callose
calms95222353calm_s_
calos74431903cal_os_
camos95927613camos_
clast76030583cl_ast
cloot76127053cl_oot
cloots85113693cloots
close76425223cl_ose
closet85226603cl_oset
clot66542423cl_o_t
clots75627643cl_ots
clout75330463cl_out
cohost115217213cohost
comose105016843comose
compost134515353compost
cost68057943__cost
cymose13429653cymose
demast9517063demast
demos86022993demos_
dimout9414243dimout
dost57248353__dost
eldest72912683eldest
elmiest9310743elmiest
elms67322703elm_s_
endmost1056763endmost
fallout10313503fallout
falsest10310013falsest
fliest94718433fliest
float85928573fl_oat
floosy12368153floosy
floss85118263fl_oss
flout86226203fl_out
frost84727833_frost
galiot72322593galio_t
galiots82311323galiots
galloot82814223galloot
galoot72719163gal_oot
galoots82410793galoots
galosh1038563gal_osh
gamest94919933gamest
gemot84024233gemo_t
gemots93712153gemots
ghost96318763_ghost
gloat65427683gl_oat
gloms85219783gloms_
gloss64319623gl_oss
glosts74513813gl_osts
glout65925813gl_out
goalpost1143853goalpost
halest94823273hal_est
hallos95425103hallos_
hallot95426783hallo_t
halmas117017893halmas_
halms105225213halm_s_
halos85230253hal_os_
headmost1445493headmost
homos105921783homos_
host77852833__host
illest63615723illest
impost103011783impost
lamas75532793lamas_
lambast11129893lambast
lambs95921413lambs_
lament85024943lament
lames75445543lames_
lamppost1443523lamppost
lamps95624833lamps_
lams66552263lam_s_
lanose6313593lanose
last46260323_l_ast
latest63822703latest
laxest134913363laxest
layout9513703layout
least56134883_least
lest46956323_l_est
limos75320813limos_
list47055343_l_ist
loft76539143_l_oft
loos49051123_loos_
loose56627683_loose
loot46955823_l_oot
loots55431423_loots
lose45144583_l_ose
loss45337963_l_oss
lot38179263_l_o_t
lots47652093_l_ots
lout45952143_l_out
lust47442603_l_ust
malmiest123211023malmiest
malms95021553malm_s_
maltose939783maltose
marmoset12411983marmoset
marmot10318743marmo_t
marmots11311513marmots
mast65959963__mast
memos95719113memos_
midmost1246153midmost
mimosa1036363mimosa
mist66154533__mist
moat66352033__moat
moist76033583__moist
molt66356163__molt
moot67653623__moot
mort66758833__mort
mos57067123__mos_
mosh95227603__mosh
mosk105622443__mosk
moss67641033__moss
moste75925083__moste
mosts76028543__mosts
mot57279423__mo_t
mots66853163__mots
mott66648443__mott
must65145443__must
mysost1138263mysost
nomos75919743nomos_
oakmoss1342533oakmoss
oldest72114093oldest
oleos55419683oleos_
olios54520853olios_
osmose8108003osmose
outmost9511213outmost
palest83926223pal_est
paliest93021613paliest
palmiest123212033palmiest
palmists12268813palmists
palms94921753palm_s_
plot66141233pl_o_t
plots75025673pl_ots
plumose1135963plumose
pomos95321583pomos_
post67953363__post
prost75434103_prost
psalmist1276353psalmist
ramose8314403ramose
rearmost1047263rearmost
rimose8310593rimose
ripost83615003ripost
roost55730933_roost
salmis8514273salmis_
salmon84614183salmo_n
salmons93713263salmons
saltest71916513saltest
salvos94613383salvos_
samosa8510203samosa
sliest66621963sliest
slosh84514483sl_osh
slot46049833sl_o_t
slots54830533sl_ots
slyest93811363slyest
smolt74824163_smolt
sumoist9311613sumoist
sumos75720093sumos_
talcose938133talcose
tallest7317093tallest
tamest85721293tamest
teleost7410523teleost
topmost1148173topmost
tost48351923__tost
utmosts934593utmosts
vamose1159283vamose
volost9412643volost
walkout1447933walkout
warmest123113033warmest
wost76544363__wost

Search took 7 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.763234195.3
2DLD Change Limit1127163905.36021029.1
3Display Results3903900.1263095.2
 (SQL Overall)1786913906.24928595.1
 
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.