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

147 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
foddered143455(None) 
doddered1234941doddered
bordered1248932bordered
dodderer1144202dodderer
fendered13258672fendered
fodder114712112fodder__
fodders124010752fodder_s
fostered122210452fostered
foundered1435402foundered
juddered1833582juddered
laddered1136742laddered
moldered1237172moldered
ordered9108532_ordered
pondered126411292pondered
powdered15256892powdered
soddened1144642soddened
soldered1038152soldered
teddered11255182teddered
wondered13239942wondered
adhered1239233_adhered
badgered1336213badgered
borderer1168103borderer
bothered142110393bothered
bouldered1344483bouldered
bowered133113043bo_wered
broidered1344933broidered
chowdered1944013chowdered
cindered1239793cindered
cockered17710213cockered
codded114515303codd__ed
codder104416343codder__
codders114114453codder_s
coddled123410573codd_led
coffered1737673coffered
cohered133514693co_hered
compered153414923compered
coopered133310943coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cottered112511743cottered
covered133315293co_vered
cowered133214653co_wered
dandered112110963dandered
dodder94712913dodder__
dodderers1243803dodderers
dodders105511793dodder_s
doddery13516853dodder_y
donnered10307753donnered
dormered1255673dormered
dowered122811553do_wered
faltered122811003faltered
fathered151510433fathered
fedexed1934083f_edexed
festered122512113festered
fettered12259493fettered
fevered14339723f_evered
fibered1337643f_ibered
fiddled13329633fidd_led
fidgeted1443893fidgeted
filtered12259043filtered
fingered13128333fingered
fleered11309503f_leered
floundered1542423floundered
flowered1546013flowered
foddering1535163foddering
folded114212793fold__ed
folder104317543folder__
folderol12103543folderol
folders113514393folder_s
fonded115717043fond__ed
fonder104120063fonder__
fondled12399423fond_led
fondued12466363fond_ued
forded115020393ford__ed
fosterer11239523fosterer
foureyed1543663foureyed
fuddled13309393fudd_led
fullered1236383fullered
gandered112211173gandered
gendered11258873gendered
godded104811803godd__ed
goffered1634523goffered
hindered1339453hindered
hoidened1335653hoidened
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
hovered143411573ho_vered
hoydened1644643hoydened
koshered1636063koshered
loitered938183loitered
loppered13326753loppered
loudened1044693loudened
louvered1244993louvered
lowered112711913lo_wered
maddened1334893maddened
modeled1139463mo_deled
modemed1336723mo_demed
mongered1238953mongered
mothered142310103mothered
mouldered1343753mouldered
murdered1236033murdered
nodded94012123nodd__ed
nodder84811943nodder__
nodders94410263nodder_s
noddled10358563nodd_led
ochered132610283_ochered
odder74515393_odder__
odored8399223_o_dored
offered1436143_offered
orderer8127943_orderer
osiered837123_osiered
overed102216623_o_vered
pandered121812573pandered
podded115012713podd__ed
ponderer112410193ponderer
portered112311553portered
pothered142311043pothered
pottered112311663pottered
powderer14245593powderer
powered132911643po_wered
reddened1136423reddened
rendered102512263rendered
reordered1145383reordered
rodded93713703rodd__ed
rodeoed937883ro_deoed
rogered939553ro_gered
saddened1135343saddened
scowdered1643743scowdered
shuddered1543433shuddered
smoldered1343793smoldered
sobered102912433so_bered
sodded94113303sodd__ed
solderer947183solderer
soldiered1143763soldiered
sundered10312153sundered
tendered102510603tendered
tochered1437913tochered
toddled10328823todd_led
tottered9208703tottered
towered112911403to_wered
unordered1145293unordered
wandered132110793wandered
wildered1336633wildered
wonderer12249183wonderer
yodeled1236863yo_deled

Search took 9 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.733243780.4
2DLD Change Limit1461621477.45319611.2
3Display Results1471470.0632333.3
 (SQL Overall)1786911478.24921662.1
 
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.