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

468 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
humate11321444(None) 
hamate113319821hamate
humane112812171humane
humates122813191humates
aurate64426472aurate
comate104124842comate
curate85226242curate
hamates122917672hamates
hate78450172h__ate
homage121210602homage
human102716032huma_n
humaner12257662humaner
humans112312432humans
humble133615052humble
humvee1439202humvee
inmate82917352inmate
jugate14379462jugate
lunate6316042lunate
luxate1338082luxate
mate65154212__mate
mutate83017482mutate
nutate63017372nutate
outate62923402outate
plumate1149802plumate
pupate104213122pupate
quate144521412qu_ate
ramate83921682ramate
remate84428682remate
rugate75813812rugate
summate113611662summate
tubate82813172tubate
urate55432162_urate
abate76627843_abate
ablate82219213ablate
acuate8315633acuate
adnate72913483adnate
adulate8313233adulate
aerate64830553aerate
agate66525143_agate
agemate101210583agemate
agnate73314873agnate
alate55340323_alate
amaze166016603_amaze
animate91617213animate
ansate64517863ansate
ate37059243___ate
aubade939223aubade
augite7312613augite
aurae54128113aura_e
aurated83817793aurated
aureate72515283aureate
automate10411943automate
aviate9315203aviate
bate66552423__bate
bedmate1239433bedmate
bemata10411693bemata
berate84729023berate
binate8419773binate
blate75933783_blate
borate85026153borate
bromate11313553bromate
bubale104014623bubale
bullate93415073bullate
bumble124216893bumble
bunkmate1643963bunkmate
bursate94111203bursate
butane8313653butane
bute66739673bu__te
butte74924293bu_tte
carate84734003carate
cate66254593__cate
caudate10311353caudate
cerate84829463cerate
chamade15138433chamade
chelate122914893chelate
cholate122114933cholate
chromate15312783chromate
chute104316463chu__te
climate11312833climate
comade114415323comade
comae97128423coma_e
comake144413423comake
comates114123633comates
comte96125473com_te
crate76537403_crate
create85126373create
cremate113816183cremate
cubage1178273cubage
cumulate123110223cumulate
cuneate9311723cuneate
curare84916953curare
curated104717583curated
curates95323823curates
curite85222943curite
curtate9312643curtate
cuspate1138233cuspate
cute66440453cu__te
cymae126713013cyma_e
damage10410773damage
date56443323__date
debate94419193debate
delate73827753delate
demote94817803demote
derate74531233derate
dilate73220693dilate
donate73619503donate
ducat86225903ducat_
ducats95011763ducats
duma75524453duma__
dumas85420433duma_s
dunite7315013dunite
educate10310213educate
elate55335883_elate
eluate62315433eluate
emote75421193_emote
emulate9314123emulate
enate54428143_enate
equate152012463equate
ergate7315143ergate
estate64719763estate
exudate1537093exudate
fate75444283__fate
female11310553female
fermate122813003fermate
fixate1638733fixate
folate93320393folate
fomite113314073fomite
formate123115093formate
fugato1036223fugato
fumarate1345683fumarate
fumble133214263fumble
fume96727633fum__e
fumet105630223fumet_
fumets114311813fumets
fumette1245523fumette
fumigate1446153fumigate
furane94015493furane
furcate12310453furcate
gamete9313593gamete
gate55746573__gate
gelate73421253gelate
gemmate12418383gemmate
gemote94613023gemote
grate64932883_grate
gummata1244613gummata
gummite1236133gummite
gunite7414403gunite
guttae73210583guttae
guttate8328903guttate
gyrate104912523gyrate
hade85440193h__ade
hae67364003h__a_e
haet75659503h__aet
hake115637843h__ake
hale76052833h__ale
halite93624233halite
hamada1239913hamada
hamal104623103hama_l
hamals114816813hamals
hamaul114210863hamaul
hame97043133h__ame
hamlet113722793hamlet
hamster12810423hamster
hamulate1359013hamulate
hare76255733h__are
hastate10313913hastate
haste85927863h_aste
hat67289963h__at_
hated95734023h__ated
hater85034753h__ater
hates86742573h__ates
hath105933913h__ath
hats76858253h__ats
haulage1136913haulage
haute89521613h_aute
have106137073h__ave
haze164833393h__aze
hazmat20312263hazmat_
hazmats2136603hazmats
heat77061423h_eat_
heated104525593h_eated
heater94828303h_eater
heath115724283h_eath
heats85838403h_eats
heave114521813h_eave
helpmate1545603helpmate
hemal104419803hema_l
hematal1238953hematal
hematein1387013hematein
hematic141816733hematic
hematin121516013hematin
hematine131614673hematine
hematite131612153hematite
heme95034413hem__e
hempie132410563hempie
hermae115314473herma_e
hexade17438903hexade
hexane16379533hexane
himatia1248573himatia
hogmane1336333hogmane
homaged1497413homaged
homager13107853homager
homages131011583homages
hombre13309303hombre
home98042443hom__e
homie104622523hom_ie
horste94817413horste
housemate1445943housemate
huckle153913073huckle
huddle113712993huddle
hue66642303hu___e
huge86321653hu__ge
hula74923753hula__
hulas84920883hula_s
hum85542933hum___
humanely1643813humanely
humanest1348123humanest
humanise1348513humanise
humanity1646313humanity
humanize2247783humanize
humanly1545683humanly
humbled153711813humbled
humbler143411943humbler
humbles143215803humbles
humbly164010523humbly
humbug1434803humbug
humeri1138523humeri
humic124113243hum_ic
humid114213763hum_id
humidex2043283humidex
humiliate1444973humiliate
humiture1344123humiture
hummable1744583hummable
hummed144812673hummed
hummer133615273hummer
hummus1336243hummus
humor101110513hum_or
humored1336723humored
humors11129633humors
humour11116753humour
hump116228723hum__p
humped144015243humped
humper134115883humper
humph155712213hum_ph
humphed1835423humphed
humphs16528163humphs
humpier143110723humpier
humps126322803hum_ps
humpy155115673hum_py
hums96831423hum__s
humus106215073hum_us
humuses1237593humuses
humvees1534683humvees
hunkie133812383hunkie
hunt76445493hu_nt_
hunted104417013hu_nted
hunter94817773hu_nter
hunts86826173hu_nts
hurdle103712793hurdle
hurst85527193hurst_
hursts97213093hursts
hurt77142573hu_rt_
hurter93915853hu_rter
hurtle93512943hurtle
hurts86922823hu_rts
hustle93113993hustle
hut66457293hu__t_
huts76737443hu__ts
hutted104616333hu_tted
hydrate14239813hydrate
hyte109018943h__yte
ideate7313683ideate
image81411283_image
imamate1138093imamate
immane1038873immane
ingate73018233ingate
inhumane1364733inhumane
inmates92715763inmates
innate63917313innate
iodate7313503iodate
irate55627983_irate
jumble174012653jumble
jurat124829323jurat_
jurats134213203jurats
jute115327893ju__te
karate105320923karate
khanate1437073khanate
lanate6421263lanate
late47560483__late
legate72917453legate
ligate72519243ligate
limbate1139203limbate
lobate82915243lobate
locate83919843locate
lucite8313343lucite
luma65527523luma__
lumas75622913luma_s
lunated8310823lunated
lute46341013lu__te
luxated1535713luxated
luxates1436973luxates
lyrate94112103lyrate
lysate9388103lysate
mabe85733343__mabe
mace87345783__mace
made75440233__made
mae57659103__ma_e
mage75739123__mage
make105537883__make
malate84624553malate
male66052293__male
mammate104411273mammate
mane65052013__mane
mare64759323__mare
mat58083933__mat_
mated85537783__mated
mater74438863__mater
mates75251363__mates
matey107022663__matey
math95437443__math
mats65460283__mats
matt65752653__matt
matte75626843__matte
maze155434973__maze
metate82720533metate
mete64438133__mete
misate81222693misate
mismate111415353mismate
mite66249403__mite
mote67048083__mote
mumble123614343mumble
muriate9313363muriate
mutase82811983mutase
mutated102712253mutated
mutates92215793mutates
mute65136873__mute
negate72915573negate
nidate7313783nidate
notate63217863notate
numbat10312083numbat_
numbats1137673numbats
numerate101610393numerate
nutated83113423nutated
nutates73214973nutates
oblate82214743oblate
ohmage1295063ohmage
oleate6318883oleate
opiate8513463opiate
orate55133303_orate
ornate6315133ornate
outage72017533outage
outdate83016423outdate
outrate72323183outrate
ovate84214393_ovate
ovulate1039453ovulate
palate84226783palate
palmate113215233palmate
pate65350463__pate
pedate93117763pedate
phenate12412193phenate
phonate12411813phonate
phorate12413363phorate
pirate82322883pirate
plate74635113_plate
plumage1245503plumage
pomace123111913pomace
pomade113611333pomade
prate75135983_prate
primate111516283primate
pulsate9510233pulsate
puma85424123puma__
pumas95121563puma_s
pumice1238223pumice
pupae96515643pupa_e
pupated12319353pupated
pupates113311433pupates
quake184114643qu_ake
quale143617853qu_ale
quare143920543qu_are
quarte154115323quarte
quatre153512353qu_atre
qubyte2034243qubyte
quinate16511573quinate
quinte153414523quinte
quite144621463qu_ite
quote143714773qu_ote
rate45458763__rate
rebate84424103rebate
redate74124683redate
relate64033633relate
remade94316983remade
remake124016113remake
remated103522473remated
remates93827103remates
remote84222603remote
rotate63320343rotate
rubace10310173rubace
rubati8299693rubati
rubato8319673rubato
rugae65114763ruga_e
ruinate7312833ruinate
rumaki1235133rumaki
rumble103718813rumble
ruminate10511473ruminate
rummage1234583rummage
rumple103913013rumple
samite83020603samite
sate45556103__sate
savate9313783savate
scutate9310323scutate
sedate73019803sedate
senate63725143senate
sfumato1253683sfumato
shipmate1546143shipmate
shute84520343shu__te
sigmate10710123sigmate
skate94721543_skate
slate55438283_slate
smaze165012933_smaze
smite75224863_smite
smote75820273_smote
solate64526073solate
somata8312383somata
somite84519373somite
soulmate1047183soulmate
spate74731583_spate
squamate1945783squamate
state56237333_state
stomate9313123stomate
suave83519873su_ave
sublate9315363sublate
suite54829563su_ite
sulcate9314423sulcate
sulfate10311653sulfate
sumac99514883suma_c
sumach135310113sumach
sumacs105512103sumacs
summae103911013summae
summated13298833summated
summates122610483summates
sumpter1138873sumpter
tamale83717393tamale
tate44748603__tate
thecate123210023thecate
togate74515683togate
tomato8313453tomato
tubae74716643tuba_e
tumble103215643tumble
ukase9428493_ukase
ululate749963ululate
umami939883_umami
unite54828383_unite
unmade92911063unmade
unmake122811213unmake
unmated103317023unmated
update93810293update
uprate83916543uprate
urare56322553_urare
urase54624683_urase
urates65027763_urates
usage6410213_usage
ute35335883_u__te
vacate11314553vacate
velate93720143velate
vulgate11388433vulgate
vulvate13388323vulvate
zonate154114923zonate
zymase201997483zymase

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127164686.35617733.8
3Display Results4684680.1563000.0
 (SQL Overall)1786914686.65526850.6
 
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.