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

110 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
appalled134481(None) 
appall10379742appall__
appalls11337742appall_s
appareled1442892appareled
apparelled1552612apparelled
appealed1335602appealed
appellee1246252appellee
applied1247482app_lied
palled94625162__palled
rappelled1443702rappelled
sepalled1156902sepalled
spalled103113132_spalled
annulled944833annulled
anvilled1236483anvilled
appal95315223appa_l__
appalling1444923appalling
appals104812943appa_l_s
apparel1146003appa_rel
apparels1245123apparels
appealer1245743appealer
appeared1336143appeared
appeased1335793appeased
appellees1344033appellees
appellor1243573appellor
appended1435483appended
applaud1293903app_laud
applauded1542173applauded
apple94517673app__le_
apples104315763app__les
applet105917433app__let
applier1137903app_lier
applies11311213app_lies
apposed1247853app_osed
appraised1445593appraised
apprised1337713apprised
apprized2236543apprized
approved16115073approved
appulse1134673appulse_
appulses1234893appulses
asphalted1543113asphalted
assailed945323assailed
availed1135973a_vailed
balled94926893__balled
begalled1236023begalled
caballed1337163caballed
called94126733__called
canalled1139573canalled
catcalled1444893catcalled
cupelled1365743cupelled
dappled1336393dapp__led
dialled9510133_dialled
empaled12288953empa_led
equalled1834863equalled
expelled1895863expelled
galled84622863__galled
impaled12288513impa_led
impelled1336073impelled
inwalled1275773inwalled
lalled74218753__lalled
lapelled11227083lapelled
malled94626113__malled
mappable1635923mappable_
medalled1246893medalled
metalled1148983metalled
muralled1136423muralled
napalmed1342503napalmed
paled85538723__pa_led
pallet84232653__pallet
pallid93915283__pallid
palmed114314643__palmed
palped114513643__palped
panelled1138963panelled
papally1437973papall_y
parallel1047463parallel
parled94626283__parled
pealed95322803_pea_led
pearled10411543_pearled
pedalled1246923pedalled
petalled1138693petalled
pilled94222753__pilled
polled94022003__polled
prilled104712993_prilled
psalmed1234503_psalmed
pulled94322193__pulled
rappeled1335003rapp_eled
recalled11310803recalled
repelled113111573repelled
repolled11359623repolled
rivalled1236093rivalled
sandalled1145903sandalled
sepaled10510593sepa_led
spaller92713473_spaller
spelled103714733_spelled
spilled103613623_spilled
spiralled1244403spiralled
sprawled1434523sprawled
squalled1835943squalled
stalled83515683_stalled
tappable1436343tappable_
thralled1245803thralled
totalled935843totalled
uncalled11810923uncalled
ungalled1078463ungalled
unpolled1168943unpolled
unwalled1288653unwalled
uppiled12216593upp_iled
uptalked1533053uptalked
upwelled1434663upwelled
vialled1156843_vialled
walled104021293__walled

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.1561145455.1
2DLD Change Limit1461621106.81321453.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.01525472.7
 
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.