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

122 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
appeared133614(None) 
appealed1335601appealed
appeased1335791appeased
afeared1176832a_feared
aneared8512742a_neared
apparel1146002app_arel
appealer1245742appealer
appear10379342appear__
appears11308952appear_s
appease1137912appease_
appeaser1245952appeaser
appeases1238662appeases
appended1435482appended
coappeared1742272coappeared
lappered13288212lappe_red
papered122513172pape_red
reappeared1543012reappeared
speared104314422_speared
upreared1137072upreared
adhered1239233adhe_red
afeard1058263a_fear_d
altered83215733alte_red
ampere10514413ampe_re_
amperes11313983ampe_res
angered93013473ange_red
annealed936343annealed
appalled1344813appalled
apparat11711713app_arat
appareled1442893app_areled
apparels1245123app_arels
apparent1248263app_arent
appeal103911613appea__l
appealers1345063appealers
appeals11378673appea_ls
appearing1436893appearing
appeasers1345263appeasers
appellee1246253appellee
append1138273appe__nd
applaud1293903appla_ud
applauded1542173applauded
applied1247483app_lied
apposed1247853app_osed
appraised1445593appraised
appressed1445943appressed
apprised1337713apprised
apprized2236543apprized
approved16115073approved
ascared10399523a_scared
ashlared1253933ashlared
asperated1239313asperated
aspersed11428293aspersed
aspired1068173asp_ired
averred11237593a_verred
bleared104211253_bleared
capered123014043cape_red
cleared103612463_cleared
coppered153410543coppe_red
dapperer1335763dappe_rer
disappeared1752433disappeared
dogeared1145793dogeared
eared65139503___eared
endeared1038053endeared
feared106320433__feared
geared85317743__geared
hampered16239933hampe_red
happened1635653happe_ned
impearled1442863impearled
kippered17255623kippe_red
lappeted13255833lappe_ted
lippered13287953lippe_red
loppered13326753loppe_red
neared75119803__neared
pampered15229233pampe_red
paperer113111903pape_rer
pared86946763__p_ared
paupered13216943paupe_red
peaced115818913__peaced
peaked136117403__peaked
pealed95322813__pealed
pearled10411553__pearled
peered93819493__peered
peppered1236133peppe_red
pleaded113511263_pleaded
pleased103712073_pleased
pleated103816633_pleated
preaged11612333_preaged
prearmed1397993_prearmed
prepared132210873_prepared
rapiered1136053rapie_red
rapparee1245873rapp_aree
rappeled1335003rappe_led
rappelled1443703rappelled
reared75930013__reared
regeared1039433regeared
repealed113211873repealed
repeated113117443repeated
sapheaded1644183sapheaded
seared75232843__seared
sheared114516003_sheared
smeared104510623_smeared
spared95427493_sp_ared
speaned103411523_speaned
spearer93913663_spearer
speered103614813_speered
speired103811103_speired
sphered133512313sphe_red
spiered104412463spie_red
supered10316123supe_red
tampered13279463tampe_red
tapered102612933tape_red
teared75722153__teared
unappeased1542623unappeased
unbeared111611653unbeared
unfeared121511013unfeared
unseared91113943unseared
upbearer1243583upbearer
upheaped1633643upheaped
upheaved1733763upheaved
upleaped1334333upleaped
upsoared11154353upsoared
upstared11156573upstared
zippered22244823zippe_red

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621226.95321021.4
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.41924085.6
 
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.