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

207 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
humaner1225766(None) 
humane112812171humane_
homager13107852homager
human102716032human__
humanely1643812humanely
humanest1348122humanest
humanizer2345722humanizer
humanly1545682humanly
humans112312432human_s
humate113214442humate_
humates122813192humates
humbler143411942humbler
hummer133615272hum_mer
humper134115882hum_per
humpier143110722humpier
almner85710723alm_ner
almoner949383almoner
bumbler134013233bumbler
bummer124014103bum_mer
bumper123714343bum_per
bumpier13359203bumpier
burner83819203bu_rner
butane8313653butane_
butanes9312743butanes
caner75334773__caner
chicaner1586073chicaner
chummier1734513chummier
churner12298343chu_rner
cleaner93712303cleaner
comaker153410603comaker
cumber124016703cum_ber
cummer124414593cum_mer
cunner83915003cu_nner
damager1157983damager
damner95213433dam_ner
demander12238723demander
dumber114414173dum_ber
dumper114615213dum_per
dumpier12409653dumpier
dunner73913823du_nner
fumbler143610813fumbler
fumer105918233fum__er
fumier11310903fum_ier
funner93414103fu_nner
furane94015493furane_
furanes103214863furanes
gleaner8379773gleaner
groaner82510133groaner
gummer114615453gum_mer
gummier12349473gummier
gunner73813983gu_nner
habanera1343273habanera
habanero1343063habanero
haler85033523h__aler
hamate113319833hamate_
hamates122917683hamates
hammer138120033ham_mer
hammier143510653hammier
hamper134518653ham_per
hamster12810423hamster
hanaper1237133hanaper
hander104526433h__ander
hanger104023253h__anger
hanker134622093h__anker
hater85034753h__ater
hatmaker1785353hatmaker
haver115124463h__aver
hayer114620243h__ayer
haymaker20104773haymaker
hazer174820233h__azer
header104422543h_eader
healer94221803h_ealer
heaper114119523h_eaper
hearer94323643h_earer
heater94828303h_eater
heaver124819673h_eaver
hemmer134112643hem_mer
hempier14319003hempier
hexane16379533hexane_
hexanes17319463hexanes
hoaxer16348563h_oaxer
hogmane1336343hogmane_
hogmanes1446783hogmanes
homage121210603homage_
homaged1497413homaged
homagers1486823homagers
homages131011583homages
homer105828453hom__er
homier116416993hom_ier
homines123518643homines
honer85332093h__oner
huddler12379423huddler
huffier1637493huffier
huger94914873hu__ger
hugger114713123hu_gger
hulkier14328973hulkier
huller93919103hu_ller
humanise1348513humanise
humanised1545953humanised
humanises1448313humanises
humanism1548093humanism
humanist13410493humanist
humanity1646313humanity
humanize2247783humanize
humanized2446533humanized
humanizers2443953humanizers
humanizes2347533humanizes
humanness1443793humanness
humanoid1445713humanoid
humble133615053humble_
humbled153711813humbled
humblers15379803humblers
humbles143215803humbles
humdinger1642183humdinger
humeri1138523hum__eri
humidex2043283humidex
humidor1343533humidor
hummed144812673hum_med
hummers143813063hum_mers
humor101110513hum__or
humored1336723humored
humour11116753hum_our
humped144015243hum_ped
humpers142713523hum_pers
humphed1835423humphed
humuses1237593humuses
humvee1439203hum_vee
humvees1534683humvees
hunger104015203hu_nger
hunker133917673hu_nker
hunkier144512143hunkier
hunter94817773hu_nter
hurdler113610003hurdler
hurler94717223hu_rler
hurrier103412943hurrier
hurter93915853hu_rter
husbander1563153husbander
husker134212703hu_sker
huskier14369763huskier
hustler103410753hustler
hymned1535323hym_ned
imager9108123_imager
immane1038883immane_
inaner62213543_inaner
inhumane1364743inhumane_
insaner7310443insaner
jumbler183910273jumbler
jumper173612373jum_per
jumpier18317943jumpier
leaner64022193_leaner
limner84112873lim_ner
loaner64416503_loaner
lumber103817773lum_ber
lumper103816653lum_per
lumpier113410143lumpier
lupanar963283lupanar
macer912126943__macer
maker114127813__maker
mane65052033__mane_
maned86634103__maned
manes76648963__manes
manger94325003__manger
manner84020513__manner
manor78023933__manor
maser75029973__maser
mater74438863__mater
mazer165722423__mazer
meaner84617843_meaner
miner76933543__miner
moaner84415113_moaner
mumbler133510913mumbler
mummer93614543mum_mer
mumper123513523mum_per
number103913223num_ber
planer84122653_planer
pomander1347083pomander
pumicer1335063pumicer
pumper124415553pum_per
punner84918153pu_nner
quaker193811623qu_aker
quaver18309313qu_aver
remaker133813173remaker
romancer1247293romancer
ruiner64013643ru_iner
rumbler113514113rumbler
rummager1343593rummager
rummer104715483rum_mer
rummier11309563rummier
runner63814463ru_nner
saner54334323__saner
shunner10358643shu_nner
suaver93014233su_aver
sugarer837323sugarer
summer104017713sum_mer
summoner1245533summoner
sumpter1138873sumpter
thumper14356953thum_per
tumbler113412823tumbler
tummler11266613tummler
tuner56022683tu__ner
turner63914613tu_rner
umber94617593_um_ber
unmaker13279513unmaker
urbaner9177133urbaner
weaner93816773_weaner
womaned1337213womaned
yummier14306843yummier

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272076.32621186.7
3Display Results2072070.0802587.5
 (SQL Overall)1786912076.81226231.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.