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 “scamperer” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
scamperer154462(None) 
scampered1635231scampered
scamperers1643471scamperers
caperer113013402_ca_perer
hamperer15379092_hamperer
pamperer14228332_pamperer
scamper134613162scamp__er
scampers143611032scamper_s
scarpered1435112scarpered
scatterer11186292scatterer
simperer1237172s_imperer
stammerer1344062stammerer
stampeder14304342stampeder
tamperer12248892_tamperer
abampere1442853abampere_
abamperes1563023abamperes
ampere10514413__ampere_
amperes11313983__amperes
cambered15129003_cambered
camper124722213_camp__er
campers134220293_camper_s
campier133313273_camp_ier
camporee1449343_camporee
capered123014043_ca_pered
caperers122611723_ca_perers
careerer1038583_careerer
caterer92815943_ca_terer
chamferer19154693chamferer
clamberer15185273clamberer
comparer143611363_comparer
compeer133811553_compe_er
compere134616623_compere_
compered153414923_compered
comperes143217973_comperes
cumberer14266993_cumberer
dampener1335533_dampener
dapperer1335763_dapperer
hammerer15278143_hammerer
hampered16239933_hampered
hamperers16287533_hamperers
pampered15229233_pampered
pamperers15236863_pamperers
paperer113111903_pa_perer
sampler113212013s_amp_ler
scalper113912923scalp__er
scalpers123710863scalper_s
scammer133611973scam__mer
scammers14339773scammer_s
scamped144711963scamp__ed
scampering1745323scampering
scampies1439323scamp_ies
scamster1235303scam_ster
scareder1135793sca_reder
scarer84524613sca___rer
scarper114814823scarp__er
scarpers124712513scarper_s
scattered12197353scattered
scatterers12205043scatterers
scauper11379453scaup__er
scaupers12378173scauper_s
schmeer1475363schm_e_er
schmeered1743273schmeered
scuppered1643933scuppered
shampooer1643063shampooer
sharpener1444583sharpener
shatterer12177203shatterer
simpered1338253s_impered
simperers1335933s_imperers
slanderer1046673slanderer
slaverer11196993sla_verer
slumberer13194803slumberer
smatterer11185813smatterer
staggerer1143923staggerer
stammered1444643stammered
stammerers1443133stammerers
stampede13326163stampede_
stampeded15343923stampeded
stampeders15233203stampeders
stampedes14315183stampedes
stamper113714403stamp__er
stampers124211603stamper_s
swaggerer1442943swaggerer
swamper14349313swamp__er
swampers15317473swamper_s
swampier1544593swamp_ier
tampered13279463_tampered
tamperers13227313_tamperers
taperer92511793_ta_perer
temperer12227723_temperer
whimperer19123723whimperer
yammerer15225483_yammerer

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 Filter1786911486410.406440125.6
2DLD Change Limit148641916.45323034.4
3Display Results91910.0461978.3
 (SQL Overall)178691916.90525878.5
 
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.