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

159 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
annoyed118587(None) 
annoyer1095601annoyer
alloyed11158032alloyed
annexed1535752annexed
annoy869712annoy__
annoyers1185032annoyers
annoys967522annoy_s
cannoned11118142cannoned
enjoyed1834522enjoyed
unannoyed1342842unannoyed
unnoted8311362unnoted
aboded104912513a_boded
acned87520673acn__ed
acnode938203acnode_
acnodes1037833acnodes
adored84714243a_dored
agnized18247223agnized
agnomen1036763agnomen
alcoved1375623alcoved
allayed11138063allayed
allowed111610083allowed
analysed12166913analysed
analyzed21155703analyzed
anchored1438603anchored
ancone83916953ancone_
ancones93116343ancones
aneared8512743aneared
aneled74719283a_neled
angeled93211513angeled
angered93013473angered
angled84219093a_ngled
aniseed839403aniseed
ankled114313483a_nkled
annates72415423annates
annealed936343annealed
annelid838733annelid
annex12310883ann__ex
annexe1337813annexe_
annexes1437203annexes
annona648873anno_na
annonas738793annonas
annotated1095613annotated
announced1243293announced
annoying1246543annoying
annulet7311593annulet
annulled944843annulled
anode65021043a_node_
anodes74418763a_nodes
anole55330383a_nole_
anoles64827433a_noles
anonym1136383anony_m
anonyms1235443anonyms
ansated84214003ansated
anted66328243a_n_ted
anteed75616113a_nteed
antired82316193antired
anviled1138953anviled
anyone94612733anyone_
apnoea867093apno_ea
apposed1247853apposed
aproned10311503aproned
arbored103811603arbored
armored102610473armored
arrayed11117153arrayed
arrowed1148113arrowed
assayed1135593assayed
atoned75417543a_toned
autoed7712823auto_ed
avowed1335963a_vowed
awned96615953awn__ed
azoted16388593a_zoted
banned94721343bann__ed
bannered11299323bannered
buoyed1236693_buoyed
canned95022063cann__ed
canoed94618963cano_ed
cantoned111411523cantoned
carboyed1637183carboyed
cloyed125111563_cloyed
connoted1138863connoted
convoyed17225553convoyed
coyed114623803__coyed
decoyed14358333decoyed
denoted93512763denoted
encoded1139033encoded
encored10412103encored
endowed1248173endowed
enjoyer1744383enjoyer
ennobled1143833ennobled
ennuye973753ennuye_
ennuyee1084153ennuyee
enrobed10279253enrobed
enskyed1532503enskyed
fanned104117473fann__ed
honeyed1437773honeyed
honored11310123honored
ignored9226443ignored
indowed1237443indowed
ingoted939183ingoted
inned64118423inn__ed
intoned8811993intoned
invoked1535303invoked
joyed164811833__joyed
manned94418643mann__ed
mannered11249653mannered
mannose939243mannose_
mannoses1039083mannoses
minored10310103minored
moneyed1337493moneyed
neoned7311483_neoned
noosed75018013_noosed
nosed65524553__nosed
noted65123843__noted
panned94123433pann__ed
pennoned1136313pennoned
ployed124310563_ployed
rancored1137233rancored
ransomed1146933ransomed
samoyed1335893samoyed
snooded94110363snooded
snooked123711493snooked
snooled84513943snooled
snooped103711813snooped
snooted84213283snooted
snoozed173410133snoozed
snored74819543_snored
snowed104613623_snowed
stroyed114110863stroyed
tangoed9318833tango_ed
tanned75219953tann__ed
tannoy958353tannoy__
tannoys1055553tannoy_s
tenoned839363tenoned
toyed96019803__toyed
tutoyed1133943tutoyed
unboned103014223unboned
unbowed132610243unbowed
unboxed17249573unboxed
uncloyed1487343uncloyed
uncoded11312743uncoded
undyed1138143_undyed
unenjoyed2041993unenjoyed
unhoped13249353unhoped
unlobed10219743unlobed
unloved112310533unloved
unmoved13248903unmoved
unnamed102410273unnamed
unposed10711903unposed
unrobed102711213unrobed
unroped102812103unroped
unsowed112511053unsowed
unwooed11229773unwooed
unyoked1567123unyoked
unzoned172310653unzoned
vanned104614483vann__ed
venomed1336653venomed
wanned104318013wann__ed
wantoned12117223wantoned
winnowed1543473winnowed

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.393454684.5
2DLD Change Limit1340271596.48320673.6
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.92225814.9
 
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.