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 “armed” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

228 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
armed8632443(None) 
aimed85626051aimed
arced88224161arced
armer76924441armer
armet76739451armet
farmed125117651farmed
harmed125218831harmed
warmed124516891warmed
aahed917816442aahed
abed79734132a_bed
abled86926832abled
aced79540882a_ced
ached119227832ached
acme86924322acme_
acmes96020652acmes
acned87520672acned
acred87126352acred
acted88521732acted
added84918432added
admen84516182admen
adzed166012542adzed
aeried74221862aeried
aged67334252a_ged
agreed84712502agreed
ahed89536252a_hed
aided75828932aided
ailed66240282ailed
aimer75926822aimer
aired66032922aired
airmen82612352airmen
airted74214502airted
alarmed1037732alarmed
alme65832162alme_
almeh106214552almeh
almes75126542almes
almud84012182almud
amen66733152a_men
amend85717752a_mend
amid77036352a_mid
amped104820512amped
anted66328242anted
aped78538152a_ped
arame75026622arame_
arames84622572arames
aramid93315612aramid
arched125717322arched
arcked136211942arcked
ardeb8314522ardeb
are37874572ar_e_
area45843392ar_ea
ares45871022ar_es
argled85314552argled
argued84311172argued
arid57642712ar_id
ariel55228972ariel
ariled75620322ariled
arles56735742arles
arm58449622arm__
armada938782armada
armers85520272armers
armets84918352armets
armies85123692armies
armlet84118192armlet
armor75118052armor
armored102610472armored
arms66137492arm_s
army96624182arm_y
aroid65428342aroid
arpen74418042arpen
arse46539272arse_
arses55733872arses
artel56122742artel
ashed97829772ashed
asked106919312asked
awed88436032a_wed
awned96615952awned
axed128829612a_xed
axled135315812axled
axmen145112272axmen
bammed133913242bammed
barbed115121312barbed
barded105426422barded
bared85144482bar_ed
barfed125416382barfed
barged105822642barged
barked135027312barked
barmen105418532barmen
barned95623582barned
barred95725792barred
bermed115217722bermed
bred75130972br_ed
breed85526692breed
calmed114816382calmed
carded105424902carded
cared86050092car_ed
caried94528692caried
carked134024822carked
carmen104019342carmen
caromed123713622caromed
carped115923762carped
carted98631442carted
carved124320852carved
charmed154714252charmed
cred76530882cr_ed
creed85727392creed
cried84624282cried
dammed124214792dammed
dared75935012dar_ed
darked123919632darked
darned85018482darned
darted84620922darted
domed95423262domed
dreed75222842dreed
dried75321382dried
eared65139502ear_ed
earned74818332earned
erred65915672erred
famed115928342famed
farced125216532farced
farded114518952farded
fared95842342far_ed
farmer115017372farmer
farted105121782farted
firmed125411882firmed
formed125021172formed
framed125116522framed
freed95223542freed
fremd115010322fremd
fried95322912fried
fumed116118822fumed
gamed95126392gamed
gammed124216162gammed
garbed104815662garbed
garred85217402garred
gaumed104610322gaumed
gormed105013832gormed
greed75125692greed
grimed104714092grimed
hammed144116972hammed
hared95742182har_ed
harked145422552harked
harmer114719552harmer
harped124418402harped
homed115425422homed
inarmed10268672inarmed
ired55131872ir_ed
irked104510922irked
jammed183811502jammed
jarred144613252jarred
lamed85235292lamed
lammed113915622lammed
larded84319092larded
larked114519472larked
limed85426802limed
maimed114812662maimed
marked133921622marked
marled95523162marled
marred95421042marred
marted94425212marted
med66146742__med
mimed105622732mimed
named85223062named
narked114116742narked
normed95014542normed
oared65030652oar_ed
orbed85516192orbed
ormer75218372ormer
palmed114314642palmed
pared86946762par_ed
parged104922042parged
parked134425142parked
parled94626292parled
parred95024072parred
parsed96323892parsed
parted94228682parted
permed115217352permed
preed85128122preed
premed114617762premed
pried84426862pried
primed115118912primed
raced87635312raced
raged74829452raged
raked105831422raked
ramee74633852ramee
ramen75625192ramen
ramet75743142ramet
rammed113117302rammed
ramped114617902ramped
raped85334622raped
rared65738322rared
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
rearmed103912822rearmed
red46755802_r_ed
reed55549622_reed
rimed84826372rimed
rued55729792_rued
swarmed1367482swarmed
tamed85528512tamed
tared69340052tar_ed
tarred74720282tarred
tarted74923372tarted
termed94816702termed
timed85223612timed
treed65626732treed
tried65026912tried
trued65117692trued
unarmed101811922unarmed
urged75316032urged
urped84615282urped
varied104817862varied
varved134110602varved
warded115021042warded
wared96339872war_ed
warked144421212warked
warmer113816732warmer
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
wormed124314302wormed
wried95518562wried
yarded114714022yarded
yarned105514022yarned

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538002281.57634137.1
3Display Results2282280.0633619.0
 (SQL Overall)1786912281.95291542.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.