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

284 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
amplest1131233(None) 
ablest84721832a_blest
ambles105121862ambles_
amoles84122192amoles_
ample94720302ample__
ampler104313302ample_r
ampules1189432ampules_
amulet8419572amule_t
amulets939922amulets
apples104315762apples_
applet105917432apple_t
applets115710062applets
aptest82917512a_ptest
campiest142212132campiest
dampest12411042damp_est
imprest11310202imprest
maples104819422maples_
molest85022742_molest
samples112815452samples_
simplest122310222simplest
vampiest15237642vampiest
abeles84719393abeles_
ableist9311773a_bleist
ables75935543a_bles_
achiest12315183achiest
acquest1837173acquest
acutest94410603acutest
addles84216603addles_
addrest958633addrest
adeptest1145453adeptest
aeriest73924053aeriest
ageless8310343ageless
aglet65534143a_gle_t
aglets73915683a_glets
aidless83612073aidless
aiglet74224193aigle_t
aiglets84012913aiglets
aimless93610813aimless
airest63825263a_irest
airiest74221013airiest
airless73712043airless
aisles64721143aisles_
alert54740653a__lert
ales47067103a__les_
alist56136783a__list
almagest1146233almagest
amazes175613473amazes_
ambient11310093ambient
amble95924643amble__
ambled115116373amble_d
ambler104916453amble_r
amblers115213563amblers
ament76036543am__ent
amices105018013amices_
amides95722663amides_
amidst94913233am_idst
amies76837693am_ies_
amines84727983amines_
amnesty1244823am_nesty
amole75724593amole__
amongst1045363amongst
amorist9317643amorist
amped104820513amp_e_d
ampere10514413amp_ere
amperes11313983amperes_
ampleness1345303ampleness
amplexus1942693amplexus
amplify1744083amplify
amply125012913ampl__y
ampoules1275853ampoules_
amps86230343amp__s_
ampule10710613ampule__
ampuls1098893ampuls_
amuses85117943amuses_
amylase1237023amylase
amylene12106883amylene
amylose1237193amylose
amyls104512693amyl_s_
analyst10189323analyst
anapaest1046023anapaest
anapest9311553anapest
aneles64626293aneles_
angles74426703angles_
ankles104818383ankles_
anklet105618733ankle_t
anklets114310413anklets
anoles64827433anoles_
apes66047433a_p_es_
aplenty1237173a_plenty
appels104312793appels_
apple94517673apple__
applies11311213applies_
apres75426403a_pres_
apses76823913a_pses_
arbalest1039523arbalest
arbelest1049503arbelest
argles75218483argles_
aridest8316143aridest
arles56735743a_rles_
armless9369943armless
armlet84118193armle_t
armlets94610063armlets
armrest9310163armrest
arpent84822093arp_ent
arrest63722633a_rrest
artiest73121993artiest
artless73712513artless
ashiest10313953ashiest
ashless10318453ashless
aspect10612823asp_ect
attest62618613a_ttest
auklet104216833aukle_t
auklets11298573auklets
auldest839893auldest
aweless1038723aweless
awless939263a_wless
awnless1035923awnless
axles125219473a_xles_
azoles154614613azoles_
blest76431723__blest
bumpiest1437873bumpiest
camlet104426583cam_le_t
camlets114314623cam_lets
capless114312763capless
caplet104226813caple_t
caplets114914523caplets
compleat14710153compleat
complect1659013complect
coolest9318643coolest
crampiest15268613crampiest
damndest1276003damndest
dampness1336073dampness
dapples1238993dapples_
dimples122813213dimples_
dimpliest1436583dimpliest
dopiest103315993dopiest
dullest8312633dullest
dumpiest1338743dumpiest
empales112411433empales_
empress1138163empress
emptiest1278103emptiest
evilest10310473evilest
examples1944313examples_
fameless13259203fameless
fellest10313753fellest
foulest10313313foulest
fullest10313343fullest
gambles124016203gambles_
gamest94919933gam__est
gamiest102816233gam_iest
gammiest13339333gammiest
gapless10349993gapless
gappiest13259473gappiest
gimpiest1338483gimpiest
halest94823273_halest
hamlet113722793ham_le_t
hamlets123211403ham_lets
hammiest152610003hammiest
hapless123311333hapless
happiest152411673happiest
hempiest1539033hempiest
heppest14228143heppest
hipless12399923hipless
hippest14219753hippest
humblest15288283humblest
humpiest1538963humpiest
humpless15226333humpless
idlest74014863_idlest
illest63615723_illest
impales113311763impales_
impels10389523impels_
implant11311333implant
implead12315823implead
impled113812513imple_d
implies11312123implies_
impost103011783imp_ost
impresa1134753impresa
imprese1138143imprese
impress1137773impress
imprests1246313imprests
impurest1245913impurest
jammiest19307203jammiest
jimpest18297553jimp_est
jumpiest1936863jumpiest
lambiest122410183lambiest
lamest84722763lam__est
lamppost1443513lamppost
lest46956323___lest
limpest113712313limp_est
lipless9259553lipless
lumpiest1239253lumpiest
macles107023223macles_
maddest112311213maddest
mailes84329113mailes_
males75049793_males_
mallet84433053malle_t
mallets93318493mallets
manless93012933manless
manliest102314943manliest
maple95521143maple__
marliest102415183marliest
matiest92522453matiest
matless93014043matless
mayest114614793_mayest
maziest183613873maziest
merest84725113_merest
mildest102812063_mildest
miles74645073_miles_
modest93818453_modest
moles74747923_moles_
molests93311563_molests
mopiest113014293mopiest
mules75034293_mules_
mutest84218053_mutest
nameless10248373nameless
napless93110283napless
nappiest122510883nappiest
nimblest1236923nimblest
noblest93613563noblest
omelet8317073omele_t
omelets938333omelets
palest83926223_palest
pamphlet1745733pamphle_t
pamphlets1842753pamphlets
pappiest112611113pappiest
pest65555293__p_est
pimples133012423pimples_
pimpliest1545473pimpliest
pipiest113114493pipiest
pleat74734473__pleat
prest75736353__prest
pumpless14236373pumpless
purplest12249133purplest
rambles113118313rambles_
rammiest12299933rammiest
rampoles1238893rampoles_
raspiest10311273raspiest
realest73322433realest
rimples113114223rimples_
ripest84317943rip_est
ropiest93317773ropiest
rumples113313133rumples_
rumpless12256543rumpless
rumpliest1345313rumpliest
samlet84126563sam_le_t
samlets93813553sam_lets
sample104215013sample__
sampled123410793sample_d
sampler113212013sample_r
samplers12299403samplers
sapless93313443sapless
sappiest122612573sappiest
simples113014943simples_
simplist12249683simplist
smallest1039403smallest
smiles84522293smiles_
splent84720193_splent
stalest73720173stalest
stampless1334543stampless
supplest1248943supplest
swampiest1635023swampiest
tallest7317093tallest
tamales93216153tamales_
tameless10259903tameless
tamest85721293tam__est
tempest1139223temp_est
temples112610893temples_
templet112712003temple_t
templets12226143templets
tipless92610063tipless
topless92511123topless
trampiest13227893trampiest
tramples122610203tramples_
typiest1238203typiest
umbles103817493umbles_
unblest9411813unblest
vilest9416843_vilest
wambles143714023wambles_
wambliest16255153wambliest
waspiest1338813waspiest
wimpiest1538763wimpiest
wimples143311173wimples_
zappiest21228023zappiest
zipless18276303zipless

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 Limit1340272846.59620319.4
3Display Results2842840.0933053.8
 (SQL Overall)1786912847.09525185.5
 
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.