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

461 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
pomade11361133(None) 
comade114415321comade
pomace123111911pomace
pomaded13377861pomaded
pomades123711731pomades
comae97128422coma_e
comake144413422comake
comate104124842comate
comrade12139212comrade
homage121210602homage
made75440242__made
nomad86016182nomad_
nomads94711602nomads
noyade1036422noyade
parade94720642parade
pesade9311102pesade
pomaces132712122pomaces
pomander1347082pomander
pome85636692pom__e
pommee122813282pommee
pommie123710502pommie
posada937162posada
potage92715902potage
premade12311442premade
remade94316982remade
unmade92911062unmade
abrade9313053abrade
alcade91111513alcade
almude9399933almude
amaze166016603_amaze
amide86128483_amide
arcade91013643arcade
armada938783armada
aubade939223aubade
bade75140883__bade
blade85923333_blade
bode75838753bo__de
bolide9515563bolide
bombe115519313bom_be
bombed134113873bombed
borage93917013borage
borane84620213borane
borate85026153borate
boride9415903boride
brocade1238533brocade
bromate11313553bromate
bromide12269583bromide
cade76443913__cade
chamade15138453chamade
clade85821013_clade
cockade1638133cockade
code77347733co__de
coma87134853coma__
comaker153410603comaker
comakes154413643comakes
comal95125133coma_l
comas95833003coma_s
comates114123643comates
combe116223543com_be
combed135516543combed
come87547703com__e
comedo11359603comedo
comedy14378233comedy
commie124215523commie
commode1438123commode
comose105016843comose
compadre15295883compadre
compare135814993compare
comped135919873comped
comrades13149773comrades
comte96125473com_te
corrade101111043corrade
coude85022633co_ude
couvade1335063couvade
cowage12310663cowage
coxae146115183coxa_e
cymae126713013cyma_e
damage10410773damage
decade104216163decade
demode104013463demode
dolmades1245463dolmades
domain9511323domain
domaine10610503domaine
domal85619203doma_l
dome77240733dom__e
domed95423263domed_
domine92918253domine
donate73619503donate
dorado838813dorado
dosage82810003dosage
dotage82711613dotage
emyde1136383_emyde
epode85114093epo__de
epoxide1745343epoxide
evade938183_evade
facade1238803facade
fade85736343__fade
female11310553female
foamed126014403foamed
folate93320393folate
fomite113314073fomite
forage104617003forage
forbade13259103forbade
formate123115093formate
fromage1336753fromage
gambade1336383gambade
glade75121963_glade
goad66830983go_ad_
goaded94913713go_aded
goads77022853go_ads
gonad75216053gonad_
gonads84511733gonads
gourde8107933gourde
grade75126093_grade
hade85440193__hade
hamada1239923hamada
hamate113319833hamate
hexade17438903hexade
hodad10311353hodad_
hodads1147963hodads
hogmane1336343hogmane
homaged1497413homaged
homager13107853homager
homages131011583homages
hombre13309303hombre
home98042443hom__e
homed115425423homed_
homemade1645143homemade
homie104622533hom_ie
horde94623053ho_rde
humane112812173humane
humate113214443humate
image81411293_image
imide85716893_imide
immane1038883immane
inmate82917363inmate
invade10157853invade
iodate7313503iodate
iodide84812933iodide
irade65618153_irade
jade125325443__jade
lade56345983__lade
limeade1076123limeade
load56730603lo_ad_
loaded84616873lo_aded
loader74316313lo_ader
loads65323373lo_ads
loamed94414613loamed
lobate82915243lobate
locale83915653locale
locate83919843locate
lode56240113lo__de
lovage1037353lovage
mabe85733363__mabe
mace87345793__mace
mad68958713__mad_
madre85720173__madre
mads76845373__mads
mae57659113__ma_e
mage75739133__mage
make105537893__make
male66052303__male
mane65052033__mane
manmade1237963manmade
mare64759333__mare
mate65154223__mate
maze155434983__maze
mismade12129353mismade
mode75840303__mode
mome85239353mom__e
monad85519473monad_
monades103713823monades
monads94515303monads
monde85723143mo_nde
morae75831193mora_e
morale85220553morale
node513036883no__de
noma67529463noma__
nomadic1248033nomadic
nomas74726413noma_s
nome66038423nom__e
nonage7313683nonage
normande1145933normande
notate63217863notate
novae85913123nova_e
noyades1136563noyades
ode47446583_o__de
ohmage1295063ohmage
omasa749483_omasa
ombre94111803_ombre
opiate8513463opiate
orad56031693_orad_
orate55133303_orate
ovate84214393_ovate
oxide131210953_oxide
pace86345773p__ace
pad68057323p__ad_
padi76331783p__adi
padle84522343p__adle
padre86018163p__adre
pads76742953p__ads
page76036103p__age
palace104516913palace
palate84226783palate
pale66055013p__ale
palmate113215233palmate
panada94113053panada
pane64950293p__ane
paraded114014263paraded
parader103914863parader
parades104121463parades
parae76335703para_e
pare66760843p__are
parkade1437583parkade
pase65346863p__ase
passade1039233passade
pate65350463p__ate
pavane114113443pavane
pave96133893p__ave
peace95026083p_eace
peage84723563p_eage
pease75231113p_ease
pedate93117763pedate
pelage9515363pelage
peonage1048723peonage
pervade1337023pervade
pesades10310903pesades
phage115113673p_hage
phase104617213p_hase
phonate12411813phonate
phorate12413363phorate
phrase11109903phrase
pikake11115803pikake
pima85428653pima__
pimas94725103pima_s
pimped134913483pimped
pimple123512963pimple
pipage1199143pipage
pirate82322883pirate
place94824613p_lace
plage84520403p_lage
plane74929143p_lane
plate74635113p_late
plead85818463plead_
pleaded113511263pleaded
pleader103511753pleader
pleads94613953pleads
please84315733please
plumage1245503plumage
plumate1149803plumate
poach124917863po_ach
pocked154818983pocked
pod66351483po__d_
podded115012713po_dded
podite93315353podite
pods76540153po__ds
poind84217913poind_
poinded11358973poinded
poinds93511143poinds
pointe84619313pointe
poise75127893po_ise
poised94918473poised
pokable15209503pokable
poke105335363po__ke
poked125425393poked_
polar75623453pola_r
polars84419353polars
polder94019253po_lder
pole65951303po__le
poleaxe1656303poleaxe
poled84934843poled_
police102918563police
polite83625073polite
polkaed1435323polkaed
polled94022003polled
pollee83623273pollee
pom78249913pom___
pomading1437423pomading
pomanders1436223pomanders
pomatum1346393pomatum
pomelo10238663pomelo
pomes94833933pom_es
pomfret1446993pomfret
pommel12277453pommel
pommies133712843pommies
pommy14449863pom_my
pomo85828453pom__o
pomos95321583pom_os
pomp106225463pom__p
pompano1345203pompano
pompom1436493pompom
pompon1238943pompon
pomps115316193pom_ps
poms87037743pom__s
ponce95222513po_nce
ponced114314813ponced
pond75530493po_nd_
ponded105218773po_nded
ponder94521693po_nder
ponds85323403po_nds
pone65747533po__ne
ponged105619353ponged
pongee94920193pongee
ponied94920703ponied
pood75934323po_od_
poodle93112043poodle
poods85124753po_ods
pooed85226243pooed_
poohed123912523poohed
pooled94619813pooled
pooped113915943pooped
poove104514303po_ove
pope85535613po__pe
popped104117813popped
popple92710983popple
popsie103013053popsie
pore66451263po__re
pored85234513pored_
porked134717623porked
porose84818743porose
portage103013643portage
ported94223243ported
posable112212783posable
posadas1037193posadas
pose66441733po__se
posed85828413posed_
posole8314223posole
posse74722273po_sse
postage103214853postage
posted93722493posted
postie84123963postie
potable112115363potable
potages102416423potages
potash1138273potash
potato8513433potato
potman102813573potma_n
potpie103412433potpie
potsie83916033potsie
pottage103310603pottage
potted94624013potted
pottle84416103pottle
poufed12449713poufed
pouffe14448263pouffe
poularde11276573poularde
pounce105214093pounce
pound84417863pound_
pounded114112793pounded
pounder103313993pounder
pounds93714383pounds
poured95116743poured
pouted94021393pouted
powder123611903po_wder
poxed154817863poxed_
pozole1758913pozole
prase76128753p_rase
prate75135983p_rate
prebade12310283prebade
prefade1339013prefade
pride84724733p_ride
primage12169143primage
primate111516283primate
probate11414483probate
profane122111863profane
prograde1247183prograde
prolate9419793prolate
promenade1485693promenade
promine112819443promine
promise113415843promise
promoed12310083promoed
promote11313143promote
pronate9418873pronate
propane112716153propane
prorate9418733prorate
protrade1148213protrade
provide1339853provide
prude84615973p_rude
psoae74411623psoa_e
ptomain1146963ptomain
ptomaine1245533ptomaine
puma85424123puma__
pumas95121563puma_s
pumice1238223pumice
pumped133915563pumped
pupae96515643pupa_e
pupate104213123pupate
ramada9310183ramada
ramate83921683ramate
remake124016113remake
remate84428683remate
road56332113ro_ad_
roadeo7510323ro_adeo
roadie72813813ro_adie
roads66523623ro_ads
roamed95215093roamed
rode55844303ro__de
romaine9512123romaine
romaji1534893romaji
roman75424823roma_n
romance11311083romance
romano84912943romano
romans84620243romans
romped114513653romped
rotate63320343rotate
roulade857003roulade
sade55544473__sade
shade95125583_shade
smaze165012933_smaze
soave84219053so_ave
socage91012123socage
solace83415823solace
solate64526073solate
soma65635293soma__
soman75024903soma_n
somans84619303somans
somas76030373soma_s
somata8312383somata
sombre10729473sombre
some66040383som__e
somite84519373somite
sonde64622833so_nde
spade84423323_spade
spode84617703spo__de
stade64825303_stade
stomate9313123stomate
tamale83717403tamale
tirade7311693tirade
toad55830183to_ad_
toads65621073to_ads
toady96814343to_ady
togae67020113toga_e
togaed84711343togaed
togate74515683togate
tolane64316583tolane
toman75724053toma_n
tomans85419133tomans
tomato8313453tomato
tombed113812133tombed
tome67543193tom__e
tommed113310143tommed
torsade837593torsade
towage1039833towage
trade65026043_trade
tsade64311123_tsade
unlade72714153unlade
unmake122811213unmake
upgrade11215823upgrade
voyage1335473voyage
wade85237063__wade
woad85523943wo_ad_
woaded115211603wo_aded
woads94818443wo_ads
woman105818003woma_n
womaned1337213womaned
womans114613653womans
wombed14419233wombed
zoeae144412483zoea_e
zombie1937323zombie
zonae145116443zona_e
zonate154114923zonate
zouave1833573zouave
zymase201997483zymase

Search took 5 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.1401276364.3
2DLD Change Limit1127164614.68624053.8
3Display Results4614610.1433223.8
 (SQL Overall)1786914614.96935961.2
 
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.