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

225 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
pumicer133506(None) 
pumice1238221pumice_
pumiced1435171pumiced
pumicers1434351pumicers
pumices1338271pumices
fumier11310902fumi_er
juicer1536282ju_icer
plumier113510042plumi_er
policer113112682policer
pricer103918292p_ricer
pumper124415552pum_per
punier84519222puni_er
spumier1137902spumi_er
admirer1035523admirer
amice96122873_amice_
amices105018013_amices
armiger1036253armiger
bumbler134013233bumbler
bummer124014103bum_mer
bumper123714343bum_per
bumpier13359203bumpier
burier84324653buri_er
busier85219723busi_er
chicer134513603_chicer
choicer14197893choicer
cimices13279803cimices
culices113713123culices
cumber124016703cum_ber
cummer124414593cum_mer
deicer94114413_deicer
dicer85426423__dicer
duiker114110593du_iker
dumber114414173dum_ber
dumper114615213dum_per
dumpier12409653dumpier
elmier839813elmi_er
enticer91510423enticer
fumbler143610813fumbler
fumer105918233fum__er
gamier93617933gami_er
guider84313523gu_ider
gummer114615453gum_mer
gummier12349473gummier
homier116416993homi_er
humaner12257663humaner
humbler143411943humbler
humic124113243humic__
humidex2043283humidex
humidor1343533humidor
hummer133615273hum_mer
humper134115883hum_per
humpier143110723humpier
juice14311323ju_ice_
juiced1636513ju_iced
juicers1636153ju_icers
juices1549423ju_ices
juicier1635463ju_icier
jumbler183910273jumbler
jumper173612373jum_per
jumpier18317943jumpier
juniper1634023juniper
limier83518723limi_er
limiter92710853limiter
lucifer1234603lucifer
lumber103817773lum_ber
lumper103816653lum_per
lumpier113410143lumpier
lunier64617603luni_er
macer912126943__macer
mice87442233__mice_
miler75733063__miler
mimer94825763__mimer
mimicker1843313mimicker
mincer104017363__mincer
miner76933543__miner
miser75430403__miser
miter75734793__miter
mixer145017643__mixer
mumbler133510913mumbler
mummer93614543mum_mer
mumper123513523mum_per
murices112612283murices
nicer74618293__nicer
noticer937273noticer
number103913223num_ber
officer1534213officer
pacer96131613p__acer
pacier105018683paci_er
palier85023563pali_er
palmier113312173palmi_er
pamper124316663pam_per
panier84425503pani_er
paviser12489093paviser
pedicel1237813pedicel
pemican1348153pemican
pice84641093p__ice_
picker144422173p__icker
piecer105213083p_iecer
pier66035293p__i_er
piercer11337773piercer
piker115622843p__iker
pincer104019173p_incer
pinier84024693pini_er
piper96523193p__iper
pipier104913983pipi_er
pitier84019823piti_er
placer105117743p_lacer
plaice10311553plaice_
plaices11411143plaices
plainer93811983plainer
plaiter93615393plaiter
plier75221283p_li_er
plumber13339983plum_ber
plumiped1533313plumiped
plummer13298523plum_mer
plummier1434123plummier
plumper13318773plum_per
poiser84217243p_oiser
pokier124914633poki_er
police102918563police_
policed123212233policed
policers12259993policers
polices113118053polices
politer92417073politer
pomace123111913pomace_
pomaces132712123pomaces
pouncer113511233pouncer
poutier93215323pouti_er
poxier153812113poxi_er
praiser93413943praiser
prancer113613383prancer
premier113515633premi_er
price93725413p_rice_
priced115018883p_riced
pricers113915063p_ricers
prices104524543p_rices
pricey134412633p_ricey
pricier113313113p_ricier
pricker154013413p_ricker
prier75027763p_ri_er
primer105118683p_rimer
primmer134310163primmer
prizer174714883p_rizer
promiser122510673promiser
pubic114513723pubic__
puce85127883pu__ce_
puces94924633pu__ces
pucker143817633pu_cker
puddler112910753puddler
pudgier11377723pudgier
pudic104614563pudic__
puffer144610733pu_ffer
puffier1547973puffier
puggier11309383puggier
puler74826623pu__ler
pulicene1245723pulicene
puller83820813pu_ller
pulper103513273pu_lper
pulpier1148623pulpier
pulser84215193pu_lser
pumiceous1563473pumiceous
pumicing1535843pumicing
pumicite1446813pumicite
pumicites1545623pumicites
pummel12278043pum_mel
pumped133915563pum_ped
pumpers133113673pum_pers
puncher143311673puncher
punisher1335773punisher
punker123718823pu_nker
punkier133512793punkier
punner84918153pu_nner
punnier93511263punnier
punster92911103punster
punter84320023pu_nter
pupilar11125313pupilar
purer75127903pu__rer
purfler12248733purfler
purger94717233pu_rger
purifier1338573purifier
purine85321893purine_
purines94420763purines
purpler11289273purpler
purser85020473pu_rser
pursier94012753pursier
pursuer9338893pursuer
purtier93214093purtier
pusher114318283pu_sher
pushier123611093pushier
pussier93711993pussier
putter83921443pu_tter
puttier93314503puttier
puzzler17276963puzzler
quicker2247023qu_icker
quiver18278743qu_iver
ricer74726613__ricer
rimier83916273rimi_er
rubier84814743rubi_er
ruiner64013643ru_iner
rulier65016353ruli_er
rumbler113514113rumbler
rummer104715483rum_mer
rummier11309563rummier
slicer84117603_slicer
smiler83916683_smiler
smiter83616413_smiter
spicer104719313_spicer
splicer114710523splicer
sufficer16225823sufficer
suiter64121813su_iter
summer104017713sum_mer
sumpter1138873sumpter
surmiser1036763surmiser
timider1037093timider
tumbler113412823tumbler
tummler11266613tummler
ulcer7310753_u_lcer
umber94617593_um_ber
uniter64619143_uniter
unmiter9310393unmiter
upriser9218763upriser
upriver12196933upriver
voicer113910543_voicer
vomiter1237953vomiter
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.390458182.1
2DLD Change Limit1340272256.01622278.4
3Display Results2252250.0802812.5
 (SQL Overall)1786912256.48627550.3
 
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.