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

218 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
hollered123760(None) 
collared113211142collared
colleted113011652colleted
fullered1236382fullered
haltered123112552haltered
hollaed11359852holl_aed
holler93520612holler__
hollers103818232holler_s
holloaed12157392holloaed
holloed113812752holl_oed
hollooed12146492hollooed
hollowed15157022hollowed
holstered1345872holstered
homered133212712ho_mered
hoovered15195412hoovered
hovered143411572ho_vered
moldered1237172moldered
pollened1157772pollened
soldered1038152soldered
solleret8512222solleret
tillered937432tillered
volleyed1543532volleyed
alleged9389313_alleged
allured8299173_allured
altered83215733_altered
antlered938253antlered
ashlered1244623ashlered
billeted1137643billeted
bollard103210503bollar_d
bolled94722653boll__ed
bollixed1834483bollixed
bolloxed1834473bolloxed
bolstered1246083bolstered
bordered1248933bordered
bothered142110393bothered
bouldered1344483bouldered
bowered133113043bo_wered
bulleted1138393bulleted
cellared11398793cellared
choppered1964883choppered
chowdered1944003chowdered
clovered14187363clovered
cockered17710213cockered
coffered1737673coffered
cohered133514693co_hered
collaged12279963collaged
collard103712923collar_d
collaret103116703collaret
collated113615063collated
collected1447963collected
colleen939533colle_en
college102410433college_
colleger11227923colleger
colleges112410513colleges
collided12309793collided
collied103316673coll_ied
colluded12296453colluded
colored10313473co_lored
coloured1148303coloured
compered153414923compered
coopered133310933coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cottered112511733cottered
covered133315293co_vered
cowered133214643co_wered
doddered1234943doddered
dolled83518073doll__ed
dollied93811143doll_ied
dolloped1234983dolloped
donnered10307753donnered
dormered1255673dormered
dowered122811553do_wered
faltered122810983faltered
filleted1236603filleted
filtered12259043filtered
fleered11309503_fleered
flowered1546013flowered
foddered1434553foddered
followed15146273followed
fostered122210443fostered
galleried1146923galleried
galleted1038213galleted
glowered1345753glowered
goffered1634523goffered
halberd1336043halber_d
halloaed121510153halloaed
halloed113314913hall_oed
hallooed12168773hallooed
hallowed15179493hallowed
haltere103614703haltere_
halteres113414593halteres
hammered16218843hammered
hampered16239923hampered
hankered16289443hankered
havered144011453h_avered
helled104024703hell__ed
heller93322513heller__
helleri10389973heller_i
helleries122611683helleries
helleris113010183helleris
hellers103619833heller_s
hellery13329213heller_y
helloed113512423hell_oed
helmeted1435833helmeted
hilled104022223hill__ed
hiller94421633hiller__
hillers103718723hiller_s
hilloaed12136923hilloaed
hilloed113211293hill_oed
hindered1339453hindered
hogweed1534443hogwe_ed
hoidened1335653hoidened
holard10410573ho_lar_d
holder104619653holder__
holders113715903holder_s
holed95634133ho_l__ed
holier94921623holier__
holked144913663ho_l_ked
holland11349473holl_and
hollering1337743hollering
hollies103420813holl_ies
holloes103818193holl_oes
hollower14127393hollower
homebred16215893homebred
honeyed1437773ho_neyed
honored11310123ho_nored
honoured1236313honoured
hoseyed1436953ho_seyed
hosteled1237283hosteled
houseled1237283houseled
hoveled14209293ho_veled
hovelled15146843hovelled
hoverer13319823ho_verer
howled134014963howl__ed
howler123514313howler__
howlers133312353howler_s
hoydened1644643hoydened
hulled103920013hull__ed
huller93919103huller__
hullers103616263huller_s
hulloaed12105803hulloaed
hulloed11369793hull_oed
hullooed12135093hullooed
hungered13217053hungered
hunkered16186923hunkered
jollied15349273joll_ied
koshered1636063koshered
leered73816223__leered
loitered938183loitered
lolled74315823loll__ed
loller63315283loller__
lollers72713793loller_s
lolloped1134463lolloped
loppered13326753loppered
louvered1244993louvered
lowered112711913lo_wered
milleped1335173milleped
mongered1238953mongered
mothered142310103mothered
mouldered1343753mouldered
ochered132610283_ochered
offered1436143_offered
ordered9108533_ordered
osiered837123_osiered
overed102216623_o_vered
palleted1139863palleted
paltered113012483paltered
pelleted1138183pelleted
peltered112510443peltered
philtered1545493philtered
pilfered1435853pilfered
pillared11228083pillared
pollard103511143pollar_d
pollarded1344703pollarded
polled94022003poll__ed
pollee83623273polle_e_
pollees93215333polle_es
poller83921853poller__
pollers93420023poller_s
polluted1135433polluted
pondered126411293pondered
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643po_wered
rogered939553ro_gered
rolled74220243roll__ed
roller63919793roller__
rollers73117473roller_s
sheltered1335573sheltered
shouldered1542233shouldered
showered1537013sho_wered
silvered12237563silvered
smoldered1343793smoldered
sobered102912433so_bered
solderer947183solderer
soldiered1143763soldiered
soleret7321233so_leret
sollerets945253sollerets
telfered1234883telfered
tochered1437913tochered
toileted936993toileted
tolled73819033toll__ed
toller63819443toller__
tollers73217453toller_s
tottered9208703tottered
towered112911403to_wered
trolleyed1342473trolleyed
ulcered1037973_ulcered
valleyed1534013valleyed
volleyer1443163volleyer
walleyed1534153walleyed
weltered12238433weltered
wildered1336633wildered
wondered13239943wondered

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.1561145455.1
2DLD Change Limit1461622188.54617103.0
3Display Results2182180.0932344.1
 (SQL Overall)1786912188.79520317.3
 
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.