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

228 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
plumate114980(None) 
plumage1245501plumage
climate11312832climate
eluate62315432elu_ate
humate113214442_humate
lunate6316042_lunate
luxate1338082_luxate
palmate113215232palmate
placate11312432placate
planate9314572planate
plate74635112pl__ate
playmate1566462playmate
plicate11314512plicate
plumaged1443572plumaged
plumages1335652plumages
plume94819462plum__e
plummet13278352plummet
plumose1135962plumose
plumule1134302plumule
primate111516282primate
pulsate9510232pulsate
pupate104213122p_upate
ululate749962ululate
acuate8315633acu_ate
adulate8313233adulate
agemate101210583agemate
alate55340323al__ate
alulae6312743alula_e
aluminate1149373aluminate
alumine9412693alumine
alumnae955403alumnae
alunite7311633alunite
animate91617213animate
aurate64426473_aurate
bedmate1239433bedmate
blate75933783bl__ate
blume95619893blum__e
bromate11313553bromate
bullate93415073bullate
caudate10311353caudate
cellmate1237873cellmate
clavate1238713clavate
climates12311973climates
comate104124843_comate
cremate113816183cremate
curate85226243_curate
diplomate1476353diplomate
educate10310213educate
elate55335883el__ate
elevate101110373elevate
eluates72014683elu_ates
elute54822573elu__te
eluviate1146953eluviate
emulate9314123emulate
equate152012463equ_ate
exudate1537093exudate
fermate122813003fermate
flatmate1346393flatmate
flume106021173flum__e
flute86823753flu__te
fluxgate1942893fluxgate
formate123115093formate
gemmate12418383gemmate
globate1057823globate
glume85120463glum__e
glutamate1242543glutamate
glute66020903glu__te
hamate113319833_hamate
helpmate1545603helpmate
humane112812173_humane
humates122813193_humates
imamate1138103imamate
inmate82917363_inmate
jugate14379463_jugate
lanate6421263_lanate
late47560483_l__ate
legate72917453_legate
ligate72519253_ligate
limbate1139213_limbate
lobate82915243_lobate
locate83919843_locate
lucite8313343_lucite
luma65527523_luma__
lumas75622913_luma_s
lunated8310823_lunated
lute46341013_lu__te
luxated1535713_luxated
luxates1436973_luxates
lyrate94112103_lyrate
lysate9388103_lysate
mammate104411273mammate
mate65154223___mate
mismate111415353mismate
mutate83017483_mutate
nutate63017373_nutate
oleate6318883ol_eate
outate62923403_outate
ovulate1039453ovulate
palate84226783p_alate
paleate94120003paleate
palliate10311893palliate
palmated132511003palmated
palpate113213923palpate
pate65350463p___ate
pectate112214693pectate
peculate122414673peculate
pedate93117763p_edate
peltate92013773peltate
pennate93314033pennate
permeate12311613permeate
permute1138793permute
phenate12412193phenate
phonate12411813phonate
phorate12413363phorate
picrate112014143picrate
pileate93815923pileate
pinnate93613743pinnate
pirate82322883p_irate
placated1338453placated
placater1238013placater
placates12311753placates
place94824613pl__ace
plage84520403pl__age
plane74929143pl__ane
planulate1146903planulate
plat66048873pl__at_
platane93112303platane
plated95225773pl__ated
platen84518203pl__aten
plater84427693pl__ater
plates85432243pl__ates
plats75531373pl__ats
platy105021663pl__aty
playdate1465263playdate
playmates1646603playmates
please84315733pl_ease
pleat74734473pl_eat_
pleated103816633pl_eated
pleater93916333pl_eater
pleats85218593pl_eats
pleurae945863pleura_e
plicae10410953plica_e
plicated13310643plicated
plum85122103plum___
plumb114514073plum__b
plumbable1743323plumbable
plumbago1542013plumbago
plumbed14317273plumbed
plumber13339983plumber
plumbic1543963plumbic
plumbs12459333plum_bs
plumbum1543733plumbum
plumed114412883plum_ed
plumelet1276173plumelet
plumes104318133plum_es
plumier113510043plumier
pluming123412043pluming
plumiped1533313plumiped
plumlike1643793plumlike
plummer13298523plummer
plummeted1642163plummeted
plummets14304773plummets
plummier1434123plummier
plummy15375663plum_my
plump115315263plum__p
plumped14318643plumped
plumpen13276403plumpen
plumper13318773plumper
plumply1634223plumply
plumps124612613plum_ps
plums94619953plum__s
plumules1234663plumules
plumy124213233plum__y
plunge93811053plu_nge
plural839823plura_l
plurals936913plurals
plussage1143223plussage
plutei8408903plu__tei
polymath1875963polymath
pomace123111913p_omace
pomade113611333p_omade
populate122812093populate
prate75135983p__rate
predate10616893predate
prelate9519693prelate
premade12311443premade
primage12169143primage
primates121515933primates
private121513263private
probate11414483probate
prolate9419793prolate
promote11313143promote
pronate9418873pronate
prorate9418733prorate
pullulate1144703pullulate
pulmonate1344763pulmonate
pulsated1136853pulsated
pulsates1048813pulsates
puma85424123p_uma__
pumas95121563p_uma_s
pumice1238223p_umice
pupae96515643p_upa_e
pupated12319353p_upated
pupates113311433p_upates
pyruvate1643073pyruvate
quate144521413_qu_ate
ramate83921683_ramate
remate84428683_remate
rugate75813813_rugate
scutate9310323scutate
sfumato1253683sfumato
sigmate10710143sigmate
slate55438283sl__ate
soulmate1047193soulmate
squamate1945783squamate
stomate9313123stomate
sulcate9314423sulcate
sulfate10311653sulfate
summate113611663summate
toluate7159343tolu_ate
tubate82813173_tubate
ultimate1049203ultimate
ululated947663ululated
ululates848433ululates
urate55432163__urate
valuate102512733valu_ate
vulgate11388433vulgate
vulvate13388323vulvate

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 Filter1786911340270.516346300.4
2DLD Change Limit1340272287.87617017.1
3Display Results2282280.0763000.0
 (SQL Overall)1786912288.46821101.9
 
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.