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

144 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
hoovered1519541(None) 
hovered143411571h_overed
clovered14187362clovered
coopered133310932coopered
covered133315292_covered
havered144011452h_avered
hollered1237602hollered
homered133212712h_omered
hooved134713122hoov__ed
hoover124314432hoover__
hoovers134312702hoover_s
hoveled14209292h_oveled
hoverer13319822h_overer
louvered1244992louvered
overed102216622__overed
beavered1437503beavered
boogeyed1543723boogeyed
bordered1248933bordered
bothered142110393bothered
bowered133113043_bowered
brokered1536083brokered
choppered1964883choppered
chowdered1944003chowdered
clavered14187633clavered
cockered17710213cockered
coffered1737673coffered
cohered133514693_cohered
compered153414923compered
convened143412223convened
converged1636963converged
conversed1538683conversed
converted15311563converted
conveyed17247923conveyed
cooeed95917863coo_e_ed
cooeyed1346893coo_eyed
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cottered112511733cottered
coverer123113523_coverer
coveted133011523_coveted
cowered133214643_cowered
doddered1234943doddered
donnered10307753donnered
dormered1255673dormered
dovened12389063_dovened
dowered122811553_dowered
fevered14339723_fevered
flowered1546013flowered
foddered1434553foddered
fostered122210443fostered
glowered1345753glowered
goffered1634523goffered
governed1335193_governed
groveled13345453groveled
haltered123112553haltered
hammered16218843hammered
hampered16239923hampered
hankered16289443hankered
havened14429243h_avened
haverel13397153h_averel
hindered1339453hindered
hogweed1534443hogwe_ed
hoidened1335653hoidened
holstered1345873holstered
homebred16215893homebred
honeyed1437773h_oneyed
honored11310123h_onored
honoured1236313honoured
hooded114616743hoo__ded
hoodooed1344963hoodooed
hoofed134614893hoo__fed
hoofer124014953hoofer__
hoofers134513323hoofer_s
hooked145320553hoo__ked
hooker134820173hooker__
hookers144916513hooker_s
hooped125518183hoo__ped
hooper114518313hooper__
hoopers123616483hooper_s
hoorahed1545093hoorahed
hoorayed1544013hoorayed
hooted104422653hoo__ted
hooter94123923hooter__
hooters104520463hooter_s
hoovering1635753hoovering
hooves124815483hoov__es
hoseyed1436953h_oseyed
hosteled1237283hosteled
houseled1237283houseled
hovelled15146843h_ovelled
hover115524133h_over__
hoverers14289023h_overers
hovers124320253h_over_s
hoydened1644643hoydened
hungered13217053hungered
hunkered16186923hunkered
koshered1636063koshered
levered114212303_levered
livered113111633_livered
loitered938183loitered
loosened945453loosened
loppered13326753loppered
louvred11354663louv_red
lowered112711913_lowered
moldered1237173moldered
mongered1238953mongered
moored93814173moo__red
mothered142310103mothered
obverted1435103_obverted
ochered132610283_ochered
offered1436143_offered
ordered9108533_ordered
osiered837123_osiered
overbed132811843__overbed
overfed142510253__overfed
pondered126411293pondered
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643_powered
proverbed1743813proverbed
quavered2144813quavered
quivered2144823quivered
recovered15166733recovered
revered112819333_revered
rogered939553_rogered
severed113513863_severed
shivered15177103shivered
shoveled15195353shoveled
showered1537013showered
silvered12237563silvered
slavered12188033slavered
slivered12218103slivered
snookered1443263snookered
sobered102912433_sobered
soldered1038153soldered
tochered1437913tochered
tottered9208703tottered
towered112911403_towered
uncovered1546613uncovered
wavered142910433_wavered
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.1701051123.5
2DLD Change Limit1461621446.59322169.3
3Display Results1441440.0632285.7
 (SQL Overall)1786911446.82626178.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.