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

158 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
decamped163496(None) 
becapped1733932becapped
camped134720232__camped
damped124315582d__amped
decamp1338452decamp__
decamps1435642decamp_s
decanted122310492decanted
decapod1335432deca_pod
decayed14309332deca_yed
defamed14309832defam_ed
encamped1535022encamped
recapped1535942recapped
revamped1634142revamped
scamped144711962_scamped
amped104820513___amped
beamed115720733be_am_ed
becalmed1534813becalmed
became123213163becam_e_
becarpet1447533becarpet
beclasped1643743beclasped
bedamned1434583bedamned
benamed122911093benam_ed
camper124722213__camper
caped104931803__ca_ped
capped134721853__capped
carped115923763__carped
champed174111483_champed
clamped144012043_clamped
comped135919873__comped
cramped144712183_cramped
dammed124214793d__ammed
damned104212913d__amned
dampen114310593d__ampen
damper114117753d__amper
dapped124516763d__apped
deaconed1237493deaconed
deaired9411533de_aired
deaned84620453de_a_ned
deashed123411303de_ashed
deaved114916553de_a_ved
debagged1433723debagged
debarked16175823debarked
debarred12165633debarred
debased113310583deba_sed
debated113916083deba_ted
decade104216163deca_de_
decades113615513deca_des
decameter14137363decameter
decamping1734943decamping
decampment1954183decampment
decane93818873deca_ne_
decanes103118913deca_nes
decanter112510793decanter
decapods1444623deca_pods
decare93919153deca_re_
decares102818533deca_res
decayer13339353deca_yer
deceased1247713deceased
deceived1535893deceived
decerned1237263decerned
decided124312423dec_ided
decimated1548953decimated
decked145217623dec__ked
declaimed1544383declaimed
declared1248743declared
declassed1344993declassed
declawed1545923declawed
declined123910883declined
decocted1437683decocted
decoded123212383dec_oded
decomposed1843893decomposed
decoupled15114283decoupled
decoyed14358333dec_oyed
decreed112710253dec_reed
decried112612853dec_ried
decrypted1842763decrypted
decupled1494983decupled
decurved1534843decurved
deemed104713063de_em_ed
defaced142910973defa_ced
defame123212433defam_e_
defamer132710323defam_er
defames132812253defam_es
defanged1435433defanged
defatted1335673defatted
defoamed15356243defoam_ed
degame102713183degam_e_
degames113312623degam_es
degassed11275963degassed
degummed1542603degummed
delated93722873dela_ted
delayed123310763dela_yed
delimed11310723delim_ed
demanded13348513demanded
demarked16187223demarked
demasted1238763demasted
demoed103713443de__moed
denimed1159233denim_ed
departed1238823departed
derailed102410403derailed
deranged1137693deranged
derated93623503dera_ted
deratted1048403deratted
desalted1038313desalted
desanded11227453desanded
descanted1336673descanted
detached1537733detached
detailed10319873detailed
detained103111643detained
devalued1335013devalued
dewaxed19316053dewa_xed
dewlapped1841953dewlapped
drammed13378073d_rammed
draped105314363d_ra_ped
dreamed114310633dream_ed
dumped123814493d__umped
escaped12388853esca_ped
escarped1355163escarped
exampled2043353_exampled
heaped124516903he_a_ped
icecapped1841433icecapped
lamped114017543__lamped
leaped94317773le_a_ped
melamed1249633melam_ed
ramped114617903__ramped
reamed94326123re_am_ed
reaped94122453re_a_ped
recalled11310803recalled
recamier1237603recamier
recaned102817203reca_ned
recanted112513513recanted
recarpet12310603recarpet
reclasped1444863reclasped
recombed1536713recombed
recouped13128663recouped
remapped1534913remapped
renamed103114523renam_ed
repumped1534383repumped
resampled1454113resampled
restamped1444433restamped
retaped103814283reta_ped
revamper1533533revamper
scalped124411993_scalped
scammed14479543_scammed
scamper134613163_scamper
scaped115519553_sca_ped
scarped124314403_scarped
seamed94823883se_am_ed
stamped124812813_stamped
swamped15498443_swamped
tamped114317043__tamped
teamed95418593te_am_ed
temped113912893te__mped
tramped124312433_tramped
uncapped1556693uncapped
unclamped1664503unclamped
undamped1445333undamped
vamped144211013__vamped

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.423422437.4
2DLD Change Limit1461621587.12620511.1
3Display Results1581580.0602633.3
 (SQL Overall)1786911587.60923484.2
 
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.