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

73 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
webcams164307(None) 
webcam1545541webcam_
webcast1445552webcast
webcasts1543312webcasts
bams87044453__b_ams
beams95328173__beams
becalms1335743be_calms
became123213163be_came
becaps123811403be_caps
bedlams1237053bedlams
beldams1237053beldams
blams95023853__blams
bobcats1335993bobcats
cams87047283___cams
debags104211063deb_ags
debars94218043deb_ars
debeaks1436103debeaks
decafs124010883de_cafs
decals93717713de_cals
decamp1338453de_camp
decamps1435643de_camps
decays124612913de_cays
defoams1336193defoams
encamp1235943_encamp
encamps1335423_encamps
escars83913133_escars
exams14199083_e_xams
eyebeams1542133eyebeams
ferbams1435743ferbams
gelcaps1235203gelcaps
hepcats1436473hepcats
hubcaps1643543hubcaps
jetsams16124103jetsams
kebabs14418513keb_abs
kebars124112493keb_ars
keblahs1634563keblahs
meccas1239493mecca_s
mescals112911563mescals
mezcals20246533mezcals
mobcaps1543463mobcaps
pecans101515833pe_cans
reams75729623re__ams
rebars84019833reb_ars
recaps103615733re_caps
redcaps1247073redcaps
reteams9339563reteams
scams94423973__scams
seams75731663se__ams
sebums10369813seb_ums
teams75726513te__ams
weals85428743we__als
weans85326743we__ans
wears86030303we__ars
webers11310943web_ers
webless1237003webless
weblogs1334223weblogs
webpage1543133webpage
webpages1643053webpages
webs96622123web___s
webworms1843763webworms
wechts1446253we_chts
wekas123911793we_ka_s
welches153710313welches
welcome1445193welcome
welcomes15134753welcomes
wenches152914133wenches
wetbacks1974983wetbacks
whams135515643w__hams
wiccans1434603wiccans
wiccas1336543wicca_s
wigwams1643883wigwams
zebras1737853zebra_s
zebrass1834113zebrass

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 Filter1786911340270.406440125.6
2DLD Change Limit134027735.78323176.0
3Display Results73730.0302433.3
 (SQL Overall)178691736.21928733.1
 
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.