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

150 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
doddered123494(None) 
dodderer1144201dodderer
foddered1434551foddered
bordered1248932bordered
dandered112110962dandered
dodder94712912dodder__
dodderers1243802dodderers
dodders105511792dodder_s
doddery13516852dodder_y
donnered10307752donnered
dormered1255672dormered
dowered122811552do_wered
juddered1833582juddered
laddered1136742laddered
moldered1237172moldered
ordered9108532_ordered
pondered126411292pondered
powdered15256892powdered
soddened1144642soddened
soldered1038152soldered
teddered11255182teddered
wondered13239942wondered
adhered1239233_adhered
badgered1336213badgered
borderer1168103borderer
bothered142110393bothered
bouldered1344483bouldered
bowered133113043bo_wered
broidered1344933broidered
chowdered1944003chowdered
cindered1239793cindered
cockered17710213cockered
codded114515303codd__ed
codder104416333codder__
codders114114443codder_s
coddled123410573codd_led
coffered1737673coffered
cohered133514693co_hered
compered153414923compered
coopered133310933coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cottered112511733cottered
covered133315293co_vered
cowered133214643co_wered
dackered16116893dackered
daddled113810743dadd_led
daggered12246403daggered
daikered1495223daikered
dangered11248513dangered
daundered1294423daundered
deadened1137233deadened
diademed1344153diademed
diapered1238003diapered
dickered16117533dickered
diddled114212053didd_led
differed1635523differed
disordered1344323disordered
dithered13189293dithered
docketed16156583docketed
doctored1245613doctored
doddering1335173doddering
dodged107514683do_d_ged
dodger95817043dodger__
dodgeries1246593dodgeries
dodgers105213823dodger_s
dodgery13627783dodger_y
dogeared1145793dogeared
doggerel1143453doggerel
donnerd9427813donner_d
doodled10369463dood_led
dosseret91111513dosseret
dotterel945063dotterel
dovened12389063do_vened
doweled12269773do_weled
dozened18377453do_zened
fendered13258673fendered
fodder114712113fodder__
fodders124010753fodder_s
fostered122210443fostered
foundered1435403foundered
gandered112211173gandered
gendered11258873gendered
godded104811803godd__ed
goffered1634523goffered
hindered1339453hindered
hoidened1335653hoidened
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
hovered143411573ho_vered
hoydened1644643hoydened
koshered1636063koshered
loitered938183loitered
loppered13326753loppered
loudened1044693loudened
louvered1244993louvered
lowered112711913lo_wered
maddened1334893maddened
modeled1139453mo_deled
modemed1336723mo_demed
mongered1238953mongered
mothered142310103mothered
mouldered1343753mouldered
murdered1236023murdered
nodded94012123nodd__ed
nodder84811943nodder__
nodders94410253nodder_s
noddled10358563nodd_led
ochered132610283_ochered
odder74515393_odder__
odored8399223_o_dored
offered1436143_offered
orderer8127943_orderer
osiered837123_osiered
overed102216623_o_vered
pandered121812573pandered
podded115012713podd__ed
ponderer112410193ponderer
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powderer14245593powderer
powered132911643po_wered
reddened1136423reddened
rendered102512263rendered
reordered1145383reordered
rodded93713703rodd__ed
rodeoed937883ro_deoed
rogered939553ro_gered
saddened1135343saddened
scowdered1643733scowdered
shuddered1543433shuddered
smoldered1343793smoldered
sobered102912433so_bered
sodded94113303sodd__ed
solderer947183solderer
soldiered1143763soldiered
sundered10312153sundered
tendered102510603tendered
tochered1437913tochered
toddled10328823todd_led
tottered9208703tottered
towered112911403to_wered
unordered1145293unordered
wandered132110793wandered
wildered1336633wildered
wonderer12249183wonderer
yodeled1236853yo_deled

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621507.72018932.9
3Display Results1501500.0632381.0
 (SQL Overall)1786911507.93922508.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.