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

256 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
humored133672(None) 
humoured1444361humoured
rumored1046641rumored
armored102610472armored
homered133212712homered
honored11310122honored
humbled153711812humbled
hummed144812672hum_med
humor101110512humor__
humoral1237982humoral
humors11129632humor_s
humped144015242hum_ped
humphed1835422humphed
hundred1237142hundred
rumoured1143782rumoured
tutored837552tutored
admired1135703admired
adored84714243_adored
arbored103811603arbored
armorer9259913armorer
armoured1165223armoured
augured987193augured
authored1238263authored
autoed7712823auto_ed
bemired123410633bemired
bored85034303__bored
buboed113010003bubo_ed
bumbled144113043bumbled
bummed134211723bum_med
bumped134414003bum_ped
bumpered1536003bumpered
buoyed1236693bu_oyed
burred95820723bu_rred
chored125321883_chored
chummed17396443chum_med
chumped17379493chum_ped
churred13409173chu_rred
clamored1336953clamored
colored10313473colored
cored85044223__cored
cumbered15157963cumbered
cured85932133cu__red
curred94319263cu_rred
demoded123611123demoded
demoed103713443demo_ed
demoted114313543demoted
dumbed124012083dum_bed
dummied13346723dummied
dumped123814493dum_ped
dured75025403du__red
emoted94614923_emoted
enamored1147033enamored
encored10412113encored
euchred13106163euchred
favored1455983favored
floored11268683floored
fumbled153710493fumbled
fumed116118823fum__ed
furore9410013furore_
furores10310033furores
furred104514433fu_rred
gored75227083__gored
gummed123811663gum_med
gumtree1045873gumtree
gumweed1433943gumweed
haired105117173h_aired
haloed104717603halo_ed
hamboned1637003hamboned
hammed144116973ham_med
hammered16218853hammered
hampered16239933hampered
harbored1438643harbored
hared95742183h__ared
hatred104814333h_atred
havered144011453havered
hectored1436893hectored
heired103813043h_eired
hemmed144211463hem_med
hemoid12313513hemo_id
hired95226263h__ired
hoboed124511683hobo_ed
hoed87837983h__o_ed
hoked135326993h__oked
holed95634133h__oled
homaged1497413homaged
hombre13309303hombre_
hombres14369883hombres
homebred16215893homebred
homed115425423h__omed
homosex1936133homosex
honed95332263h__oned
honoree10412113honoree
honorer1039673honorer
honoured1236313honoured
hooded114616743h_ooded
hoofed134614893h_oofed
hooked145320553h_ooked
hooped125518183h_ooped
hooted104422663h_ooted
hooved134713123h_ooved
hoped115628183h__oped
horde94623053h__orde
horded115420483h__orded
horned105718703h__orned
horsed105321083h__orsed
hosed95830983h__osed
hovered143411573hovered
huddled13349783huddled
hued86925853hu___ed
huffed163710153hu_ffed
hugged124113643hu_gged
hulked144611303hu_lked
hulled103920013hu_lled
hulloaed12105803hulloaed
hulloed11369793hulloed
hullooed12135093hullooed
humane112812173humane_
humaner12257663humaner
humate113214443humate_
humates122813193humates
humble133615053humble_
humbler143411943humbler
humbles143215803humbles
humdrum1543523humdrum
humeral1238573humeral
humeri1138523humer_i
humerus1236923humerus
humid114213763hum__id
humidex2043283humidex
humified1745653humified
hummer133615273hum_mer
hummers143813063hummers
hummocked2341903hummocked
humorful1642273humorful
humoring1456853humoring
humorist1348783humorist
humorless1442963humorless
humorous1346453humorous
humour11116753humo_ur
humours1286443humours
humper134115883hum_per
humpers142713523humpers
humpier143110723humpier
humuses1237603humuses
humvee1439203hum_vee
humvees1534683humvees
hunched163710493hunched
hundreds1344003hundreds
hungered13217053hungered
hunkered16186923hunkered
hunted104417013hu_nted
hurdled12379833hurdled
hurled104617453hu_rled
hurried113511043hurried
hurtled11339593hurtled
hushed134416673hu_shed
husked144212223hu_sked
hustled113210133hustled
hutched16359883hutched
hutted104616333hu_tted
huzzaed1943103huzzaed
hymned1535323hym_ned
hypoed1547923hypo_ed
ignored9226443ignored
immured1235063immured
jumbled19379963jumbled
jumped183511553jum_ped
labored102810253labored
lumbered13188233lumbered
lumped114216963lum_ped
lured65427493lu__red
lustred8359053lustred
majored1735853majored
minored10310103minored
mired85729223__mired
mooed85123983__mooed
moored93814173_moored
moped105424733__moped
more67154523__more_
morel75729093__morel
mores76249643__mores
motored1039933motored
moved114218153__moved
mowed113629013__mowed
mumbled143010763mumbled
mummed104411553mum_med
mummied11327103mummied
mumped133813163mum_ped
mured85726703__mured
murmured1343113murmured
numbed114111443num_bed
numbered13147143numbered
odored8399223_odored
osmosed10134843osmosed
outbred10311263outbred
outhumored1642303outhumored
outmoded12207703outmoded
outmoved14247283outmoved
pored85234513__pored
pumiced1435173pumiced
pumped133915563pum_ped
purred94218073pu_rred
queered17117223queered
quired163711953qu_ired
quoted16359453qu_oted
razored1736333razored
rebored105015883rebored
remorid10311863remorid
removed134611313removed
rhumbaed1672753rhumbaed
rumbaed12287493rumbaed
rumbled124514593rumbled
rumor71011323rumor__
rumors81110403rumor_s
rumpled123810013rumpled
samoyed1335893samoyed
savored1158343savored
scored94621133_scored
shamoyed1744043shamoyed
shored105723653_shored
smoked134311723_smoked
snored74819543_snored
sored66141783__sored
spoored104411293spoored
spored94821793_spored
stored75524213_stored
suborned1137303suborned
succored13135173succored
sugared938583sugared
summed114014043sum_med
summered1338143summered
summoned1345723summoned
supered10316123supered
sutured8310373sutured
tabored102810563tabored
thumbed15336173thum_bed
thumped15387413thum_ped
tumbled123412243tumbled
tumbrel11406853tumbrel
tumor71110693tumor__
tumoral938133tumoral
tumors8810613tumor_s
tumped114216233tum_ped
tutoyed1133943tutoyed
umbered121510113_umbered
umped104717273_um_ped
umpired1235783_umpired
unbred92613303_unbred
unmoored1137333unmoored
unmoved13248903unmoved
vamosed1335923vamosed
vapored1336923vapored
visored1138143visored
vizored2034133vizored
whored135512123_whored
whumped18335633whum_ped

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272567.01319111.2
3Display Results2562560.0962666.7
 (SQL Overall)1786912567.51523777.9
 
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.