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

227 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
admired113570(None) 
admire949931admire_
admirer1035521admirer
admires1038661admires
admixed1833731admixed
adhered1239232adhered
adjured1634882adjured
admiral1046362admiral
admirers1134712admirers
admitted1234762admitted
admixes1765962admixes
adored84714242ad_ored
advised12136042advised
aired66032922a__ired
antired82316192antired
armored102610472armored
aspired1068172aspired
attired8238912attired
bemired123410632bemired
coadmired1542742coadmired
mired85729222__mired
unadmired1343862unadmired
abided105313313a_bided
abjured1735083abjured
acquired2044043acquired
acred87126353a__cred
adapted1135843adapted
added84918433ad__ded
addicted1345073addicted
addled94112523ad_dled
adduced1274353adduced
adeemed1145393adeemed
adhere10310333adhere_
adherend1343863adherend
adherer1137573adherer
adheres11310163adheres
adieu6417423ad_i_eu
adjoined1743513adjoined
adjure1435843adjure_
adjurer1534823adjurer
adjures1536233adjures
admen84516183adm__en
admirals1144353admirals
admiring1236133admiring
admit8319493admi__t
admits9411413admi_ts
admittee1145133admittee
admitter1135113admitter
admix1557733admi__x
admixt1637333admi_xt
adopted1136253adopted
adore65723673ad_ore_
adorer74713453ad_orer
adores74420723ad_ores
adorned9256893adorned
adsorbed1243443adsorbed
adverted1336103adverted
advice12107883advice_
advices13136933advices
advise10139223advise_
advisee11147153advisee
adviser11135783adviser
advises11138973advises
adzed166012543ad__zed
aeried74221863aeri_ed
afeared1176833afeared
affined1436413affined
affirmed1743213affirmed
affixed2134123affixed
afire86215913a_fire_
agnized18247223agnized
aided75828933a__ided
ailed66240283a__iled
aimed85626053a__imed
airer54927893a__irer
airted74214503a__irted
alined75221403a_lined
aliped95414283a_liped
allied74217153alli_ed
allured8299173allured
altered83215733altered
amazed18519313a_mazed
ambled115116373a_mbled
amerced1256523a_merced
amice96122873a_mice_
amices105018013a_mices
amid77036353a_mi__d
amide86128483a_mide_
amides95722663a_mides
amie66339853a_mi_e_
amies76837693a_mi_es
amine75835383a_mine_
amines84727983a_mines
amir65129753a_mir__
amirs75924923a_mir_s
ammine10314493ammine_
ammines11312673ammines
amped104820513a_m_ped
amused94412513a_mused
aneared8512743aneared
angered93013473angered
anviled1138953anviled
arbored103811603arbored
ariled75620323a_riled
armed86324433arm__ed
armies85123693armi_es
armiger1036253armiger
armoire938133armoire_
armoires1057623armoires
armorer9259913armorer
armoured1165223armoured
armure8710133armure_
armures9510273armures
arrived11127353arrived
ascared10399523ascared
aspire8612123aspire_
aspirer967903aspirer
aspires9612043aspires
assured858373assured
atomised11278833atomised
atomized20279323atomized
attire62412383attire_
attires72312953attires
audited939033audited
augured987193augured
availed1135973availed
averred11237593averred
avoided1235553avoided
awaited1146963awaited
axised14438963a_xised
badgered1336213badgered
bemire103312803bemire_
bemires113212833bemires
bemixed19337053bemixed
caddied123710563caddi_ed
caddised13315893caddised
chaired134211243chaired
choired13349343choired
coadmire1344043coadmire_
coadmires1444033coadmires
damaged1257453damaged
dammed124214793dam_med
damned104212913dam_ned
damped124315583dam_ped
dared75935013_d_ared
deaired9411533deaired
deiced104214483_deiced
demirep1236213demirep
demised113613683demised
desired9311983desired
diced95824683_d_iced
died66137853_d_i_ed
diked115024683_d_iked
dimmed124110323_dimmed
dined76431993_d_ined
dire56644143_d_ire_
direr64927073_d_irer
dirked124912273_d_irked
dirled84514903_d_irled
dived106321373_d_ived
doiled84817293_doiled
doited85016633_doited
dried75321383_dri_ed
dured75025403_d_ured
dwined114610213_dwined
eddied9248323eddi_ed
edited83913673ed_ited
ermined10410603ermined
expired1736403expired
faired105915773_faired
fired94829743__fired
glaired9387743glaired
haired105117173_haired
hammered16218853hammered
hardwired1742873hardwired
heired103813043_heired
hired95226263__hired
homered133212713homered
humored1336723humored
immixed1933573immixed
immured1235063immured
ired55131873___ired
laddered1136743laddered
laired75216813_laired
limited102310233limited
mammered12237653mammered
miked125020453__miked
mimed105622733__mimed
mined85333353__mined
mire66748233__mire_
mires75640883__mires
mirex146816623__mirex
mitred94414343__mitred
mixed155717253__mixed
mured85726703__mured
odored8399223od_ored
paired95017523_paired
pumiced1435173pumiced
quired163711953_quired
radioed939673rad_ioed
refired115116993refired
rehired115013153rehired
remised103516843remised
remixed173510743remixed
retired84620143retired
rewired115413283rewired
rumored1046643rumored
sired66134283__sired
smiled93716433_smiled
smirked14307233_smirked
speired103811103speired
spired94921863_spired
squired173710063squired
tired65228903__tired
umpired1235783umpired
unaired82916013unaired
unfired112212453unfired
unhired112512153unhired
unmined102612953unmined
unmitred1136843unmitred
unmixed17228213unmixed
untired82316383untired
vomited1337253vomited
waddied13358563waddi_ed
waired106015833_waired
wired95327643__wired
yammered16225763yammered

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272276.62320236.6
3Display Results2272270.1561455.1
 (SQL Overall)1786912276.93525766.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.