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

89 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
scampering174532(None) 
scarpering1545411scarpering
cambering16109872_cambering
capering132414962_ca_pering
compering163414162_compering
hampering1738862_hampering
pampering1638382_pampering
scamping153510192scamp__ing
scattering1398012scattering
schmeering1843432schmeering
scuppering1754022scuppering
simpering1449292s_impering
stammering1544522stammering
stampeding1642982stampeding
tampering1438452_tampering
bumpering1636593_bumpering
calipering1545003_calipering
cameoing1379063_cam_eoing
campesino1544633_campesino
camping143118973_camp__ing
campusing1654913_campusing
cankering162110793_cankering
cantering122417383_cantering
careering12311203_careering
carpeting1439483_carpeting
catering112019913_ca_tering
chambering20116043chambering
chamfering21125333chamfering
clambering1776163clambering
comparing162410583_comparing
compeering1747053_compeering
competing163712463_competing
coopering142611323_coopering
coppering162810893_coppering
cumbering16108203_cumbering
dampening1535463_dampening
diapering1339033dia_pering
hammering1737633_hammering
lappering14258843_lappering
mammering1337333_mammering
papering132213313_pa_pering
paupering1437273_paupering
sabering112113743s_a_bering
saggering12197793s_aggering
sampling13510643s_amp_ling
scalping133410453scalp__ing
scamming15328543scam__ming
scamper134613163scamper___
scampered1635233scamper_ed
scamperer1544623scamper_er
scamperers1643473scamperers
scampers143611033scamper__s
scaping123715693sca_p__ing
scaring103421973sca___ring
scarphing1735243scarp_hing
scarping133312463scarp__ing
scarring112511513sca__rring
scatterings14103973scatterings
sceptering1545793sceptering
sceptring1444273sc_eptring
schmearing1842863schmearing
scowdering1743983scowdering
scunnering1344133scunnering
scuttering1386633scuttering
shampooing1843093shampooing
sharpening1644883sharpening
shattering1498283shattering
shimmering1884623shimmering
simmering1467823s_immering
skippering1943673skippering
slabbering15104973slabbering
slandering1237243slandering
slathering14108283slathering
slavering1338723sla_vering
slumbering15105323slumbering
smattering1397583smattering
spattering13107793spattering
staggering13194583staggering
stamping133310963stamp__ing
steamering1345443steam_ering
stoppering1544613stoppering
summering1458753s_ummering
supering11317683s__upering
swaggering16233623swaggering
swamping16307923swamp__ing
tapering112112503_ta_pering
tempering1438733_tempering
whimpering2143853whimpering
yammering1735193_yammering

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 Filter1786911406030.403443402.0
2DLD Change Limit140603896.78320728.7
3Display Results89890.0461934.8
 (SQL Overall)178691897.23224708.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.