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

231 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
aimed8562605(None) 
aided75828931aided
ailed66240281ailed
aimer75926821aimer
aired66032921aired
armed86324431armed
limed85426801limed
maimed114812661maimed
mimed105622731mimed
rimed84826371rimed
timed85223611timed
aahed917816442aahed
abed79734132a_bed
abided105313312abided
abled86926832abled
aced79540882a_ced
ached119227832ached
acme86924322acme_
acmes96020652acmes
acned87520662acned
acred87126352acred
acted88521732acted
added84918432added
admen84516182admen
adzed166012542adzed
aged67334252a_ged
ahed89536252a_hed
aid49269072ai__d
aide56044992aide_
aider65431132aider
aides65336602aides
aidmen92610372aidmen
aim57858212aim__
aimers84621912aimers
aims67738182aim_s
airer54927892airer
airmen82612352airmen
airted74214502airted
aisled74516182aisled
aiver85725162aiver
alined75221402alined
aliped95414282aliped
alme65832162alme_
almeh106214552almeh
almes75126542almes
almud84012182almud
amen66733152a_men
amend85717752a_mend
amid77036342a_mid
amide86128482amide
amie66339852amie_
amies76837692amies
amped104820512amped
anime75423202anime_
animes84719592animes
anted66328242anted
aped78538152a_ped
arced88224162arced
ariled75620322ariled
armer76924442armer
armet76739452armet
ashed97829772ashed
asked106919312asked
awed88436032a_wed
awned96615952awned
axed128829612a_xed
axised14438962axised
axled135315812axled
axmen145112272axmen
bailed94726652bailed
baited95319242baited
bammed133913242bammed
bided95424962bided
biked125320032biked
biped104718832biped
calmed114816382calmed
chimed145814832chimed
cimex16119132cimex
cited84421952cited
claimed12298832claimed
daimen92210572daimen
dammed124214792dammed
diced95824682diced
died66137852di_ed
diked115024682diked
dime76237642dime_
dimer85625602dimer
dimes85833042dimes
dimmed124110322dimmed
dined76431992dined
dived106321372dived
domed95423262domed
failed105421602failed
faired105915772faired
famed115928342famed
farmed125117652farmed
fifed125115972fifed
filed95331902filed
filmed124610362filmed
fined94930502fined
fired94829742fired
firmed125411882firmed
fixed165416952fixed
fumed116118822fumed
gained84617462gained
gaited84416922gaited
gamed95126392gamed
gammed124216162gammed
gaumed104610322gaumed
gibed96215962gibed
gied64631982gi_ed
gimel8313352gimel
gimped123911472gimped
glimed105312282glimed
grimed104714092grimed
hailed104122742hailed
haired105117172haired
hammed144116972hammed
harmed125218832harmed
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hired95226262hired
hived125217912hived
homed115425422homed
iced78721892_iced
imbed105013652_imbed
imid76122292_imid
imped105117982_imped
ired55131872_ired
jailed144917422jailed
jammed183811502jammed
jibed155114162jibed
jived165115042jived
kited105120092kited
laired75216812laired
lamed85235292lamed
lammed113915622lammed
lied55838092li_ed
liked104523812liked
limbed114513182limbed
lime66244932lime_
limen75426032limen
limes75636502limes
limey104721042limey
limned94811472limned
limped114817122limped
lined64934642lined
lived95523722lived
mailed95326752mailed
maimer104514592maimer
med66146742__med
miked125020452miked
mime85736402mime_
mimeo96018682mimeo
mimer94825762mimer
mimes95732022mimes
mined85333352mined
mired85729222mired
mixed155717252mixed
nailed74021492nailed
named85223062named
nided75920872nided
nimmed11368572nimmed
nixed135714222nixed
oiled64429472oiled
paiked135113432paiked
pained95622852pained
paired95017522paired
palmed114314642palmed
pied75035362pi_ed
piked125623312piked
piled85232992piled
pimped134913482pimped
pined85935322pined
piped105123162piped
primed115118912primed
raided85017702raided
railed74727542railed
rained75024602rained
raised76120332raised
rammed113117302rammed
riced85825542riced
riled65833252riled
rime65138882rime_
rimer75429242rimer
rimes75634542rimes
rimmed114812302rimmed
riped85226432riped
rived94825612rived
sailed74327762sailed
sained75424242sained
sided74825952sided
siped84927682siped
sired66134282sired
sited65130742sited
sized155519242sized
slimed94915122slimed
tailed74424662tailed
tamed85528512tamed
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
time66235012time_
timer75626042timer
times75630822times
timid84815722timid
tined65434532tined
tired65228902tired
unaimed102812492unaimed
vailed104619292vailed
viced115118182viced
vied86328632vi_ed
vimen104114752vimen
vined95626152vined
vised95518762vised
waifed134011032waifed
wailed104823592wailed
waired106015832waired
waited103819772waited
waived134511282waived
warmed124516892warmed
wifed125117742wifed
wiled95231552wiled
wimped144211512wimped
wined94434182wined
wiped114722082wiped
wired95327642wired
wised95123342wised
wited94727142wited
wived125121502wived

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.0931921408.6
2DLD Change Limit538002311.68631909.8
3Display Results2312310.0633666.7
 (SQL Overall)1786912311.84297009.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.