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

135 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
teddered1125518(None) 
tendered102510601tendered
doddered1234942doddered
fendered13258672fendered
foddered1434552foddered
gendered11258872gendered
juddered1833582juddered
laddered1136742laddered
reddened1136422reddened
rendered102512262rendered
tedded93810892tedd__ed
tedder83312152tedder__
tedders94010232tedder_s
teetered9258302teetered
telfered1234882telfered
tempered13248212tempered
tenderer9228732tenderer
tentered96412102tentered
tethered1238492tethered
adhered1239233_adhered
badgered1336213badgered
beavered1437503beavered
bedded115114063bedd__ed
bedder104215783bedder__
bedders113513383bedder_s
bedewed1437153be_dewed
bettered113011833bettered
bordered1248933bordered
centered112513523centered
cindered1239793cindered
dandered112110963dandered
deadened1137233deadened
dodderer1144203dodderer
eddied9248323_edd_ied
endeared1038053_endeared
endured93611213_endured
entered82718883_entered
fedexed1934073fe_dexed
festered122512103festered
fettered12259493fettered
fevered14339723fe_vered
gandered112211173gandered
gettered10258613gettered
hindered1339453hindered
jeered143912793je__ered
kedgeree1444373kedgeree
leadened1036153leadened
lechered1437523lechered
leered73816223le__ered
lettered92910783lettered
levered114212303le_vered
maddened1334893maddened
meandered1346143meandered
meddled123210033medd_led
membered1535903membered
metered103514013me_tered
moldered1237173moldered
murdered1236023murdered
neutered937423neutered
ordered9108533_ordered
pandered121812573pandered
peddled123410533pedd_led
peered93819483pe__ered
peltered112510443peltered
peppered1236123peppered
perdured12287383perdured
pestered112814953pestered
petered103314963pe_tered
pondered126411293pondered
powdered15256893powdered
redded94019543redd__ed
redder83918133redder__
redders93615343redder_s
reddled102912323redd_led
redeemed1235593redeemed
renderer9239743renderer
reordered1145383reordered
revered112819333re_vered
saddened1135343saddened
severed113513863se_vered
sewered112911243se_wered
shuddered1543433shuddered
soddened1144643soddened
soldered1038153soldered
steamered1244913steamered
steered83615253ste__ered
sundered10312153sundered
tabered103311593t_abered
tampered13279463tampered
tapered102612933t_apered
tattered92011443tattered
teared75722153te__ared
teaseled9186793teaseled
teazeled18194233teazeled
teddering12256303teddering
teddies92711283tedd_ies
teemed95114873te__emed
telexed1536313te_lexed
telneted935073telneted
telphered1544213telphered
temperer12227723temperer
tended83819483tend__ed
tender74121843tender__
tenderers10227803tenderers
tenderest1047903tenderest
tenderized2175153tenderized
tenderly1245293tenderly
tenders83719723tender_s
tenured838363te_nured
textured1695483textured
thundered1444573thundered
tiered73613973t__iered
tillered937443tillered
timbered13137383timbered
tinkered1387683tinkered
tittered9239493tittered
tochered1437913tochered
toddled10328823todd_led
tottered9208703tottered
towered112911403t_owered
treddled1134473tredd_led
tuckered1535963tuckered
veered103612743ve__ered
veneered1235983veneered
verderer1245373verderer
verdured13255763verdured
wandered132110793wandered
wedded123811833wedd__ed
wedder113612293wedder__
wedders123610723wedder_s
wedeled1237783we_deled
weltered12238433weltered
westered122511863westered
wildered1336633wildered
wondered13239943wondered

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621356.39322862.8
3Display Results1351350.0602250.0
 (SQL Overall)1786911356.60927037.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.