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

74 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
webcast144555(None) 
webcasts1543311webcasts
recast83422772re_cast
webcam1545542webca_m
webcams1643072webcams
webcasted1741972webcasted
webcaster1642382webcaster
bast66362413__b_ast
beast76338643__beast
bedfast1346413bedfast
blast76532573__blast
boast75935703__boast
bobcat12411253bobca_t
bobcats1335993bobcats
cast67159903___cast
debase94014473deb_ase
decant93524223de_cant
demast9517063de_mast
descant104315593descant
dicast9315573_dicast
east46659103_e__ast
encase83714363_encase
encash11276943_encash
encyst1136203_encyst
feast85932723fe__ast
heliast10312073heliast
hepcat13611823hepca_t
hepcats1436473hepcats
least56134883le__ast
meccas1239493meccas_
miscast11312423miscast
newscast1343433newscast
oblast8613663_oblast
offcast1544473offcast
opencast1244873opencast
outcast91013743outcast
overcast132411973overcast
peccant13311733peccant
peltast9310513peltast
precast11314853precast
rebait8320403reb_ait
reboant9315093reboant
recant83228683re_cant
recasts93413533re_casts
repast83520633re_past
seacoast1047783seacoast
secant84023293se_cant
subcaste1287853subcaste
teacart91113193teacart
telecast1048303telecast
uncast84215713_uncast
upcast102710093_upcast
wast75655853w___ast
weakest1439003weakest
webbiest1535353webbiest
webcasters1742143webcasters
webcasting1842483webcasting
webers11310943webers_
webfeet1544593webfeet
webfoot1544213webfoot
webless1237003webless
webmaster1643003webmaster
webpage1543133webpage
webs96622123web__s_
wecht13415443we_c_ht
wechts1446253we_chts
weest85026773we__est
wekas123911793we_kas_
west75748083we___st
wettest10239363wettest
wiccas1336543wiccas_
yeast85327943ye__ast
zebras1737853zebras_
zebrass1834113zebrass

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 Filter1786911340270.436409841.7
2DLD Change Limit134027747.33018284.7
3Display Results74740.0135692.3
 (SQL Overall)178691747.77922970.9
 
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.