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

156 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
tethering133913(None) 
bettering122212752bettering
blethering16115932blethering
bothering152210202bothering
dithering1499852dithering
fathering161010092fathering
feathering17108792feathering
fettering132310512fettering
gathering1499462gathering
gettering112310032gettering
lathering13912252lathering
leathering1488682leathering
lechering1538442lechering
lettering102112072lettering
metering112915632met_ering
mothering152110182mothering
petering112516812pet_ering
pothering151911282pothering
tattering102212322tattering
teddering12256302teddering
teetering10239892teetering
telfering1336252telfering
telphering1644202telphering
tempering1438732tempering
tendering112210812tendering
tentering102313202tentering
tittering102310312tittering
tochering1537152tochering
tottering10229612tottering
untethering1543682untethering
weathering1798352weathering
withering16108812withering
wuthering1697802wuthering
adhering1338883_adhering
aetheric13410163aetheri_c
altering91917113alt_ering
antheming1587293antheming
atheling1249203_atheling
authoring1348583authoring
battering122715143battering
beavering1538703beavering
bethorning1644203bethorning
bittering122511993bittering
blathering16107583blathering
blithering16116123blithering
brothering1646033brothering
butchering1844503butchering
buttering122312523buttering
catering112019903cat_ering
centering122915143centering
ciphering17217703ciphering
cohering142413833_cohering
coshering15510023coshering
cyphering20175243cyphering
deterging1237853det_erging
deterring1138623deterring
detouring1136973detouring
entering91920053_entering
etheric12311783_etheri_c
etherify1744443_etherify
etherish1448273_etherish
etherize2049463_etherize
etherizing2346853_etherizing
featherings18105373featherings
festering132413173festering
fevering152510083fe_vering
furthering1744353furthering
gatherings15105293gatherings
gendering12249753gendering
guttering112410443guttering
inhering12913713_inhering
jeering153513043je__ering
jittering17218423jittering
kashering1736253kashering
koshering1735363koshering
leering83417643le__ering
letterings11226003letterings
levering122212503le_vering
littering102411983littering
mattering122314053mattering
methedrine1644713methedrine
metring103215293met__ring
mitering113015403mit_ering
motherings16255643motherings
murthering1644473murthering
muttering122611323muttering
nattering102212213nattering
neutering1038963neutering
ochering14219393_ochering
outhearing1438443outhearing
pattering122314423pattering
peering103520353pe__ering
peltering122011673peltering
peppering1337083peppering
pestering122315663pestering
pottering122612003pottering
puttering122611643puttering
rechewing1836493rechewing
regathering1645203regathering
rehearing132211763re_hearing
rehiring122911883re_hiring
rendering112213183rendering
retearing102214253retearing
retieing92913713retie_ing
retiring92717413ret_iring
reuttering1137573reuttering
revering122918073re_vering
severing122013853se_vering
sewering122411093se_wering
slathering14108283slathering
slithering1496893slithering
smothering1646013smothering
sphering142811943_sphering
steamering1345443steamering
steering93916793_steering
stretchering1852453stretchering
stuttering1196353stuttering
swithering17105213swithering
syphering18175733syphering
tabering112211423t_abering
tampering1438453tampering
tapering112112503t_apering
tearing84021493te__aring
teaseling1036913teaseling
teazeling1934543teazeling
teeing73916973te__e_ing
teeming103513093te__eming
teething1237163teeth__ing
telexing1646613te_lexing
telneting1035593telneting
tenuring938863te_nuring
tether93716103tether___
tethered1238493tether_ed
tethers103815313tether__s
texturing1735223texturing
theming133610473__theming
tiering8315253__tiering
tillering1037883tillering
timbering14117723timbering
tinkering1437703tinkering
tithing113513893tith__ing
towering122610873t_owering
tuckering1635693tuckering
tutoring938433tut_oring
tutoyering1442253tutoyering
twittering1444583twittering
tything14316573tyth__ing
ushering1258923_ushering
uttering91613083_uttering
veering113213683ve__ering
veneering1337663veneering
watering122316313wat_ering
weatherings1895263weatherings
weltering13219493weltering
westering132112643westering
yattering132410443yattering

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411566.87321626.8
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.34224338.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.