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

184 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
pumicing153584(None) 
juicing1736882ju_icing
policing13311672policing
pricing123417342p_ricing
pumicite1446812pumicite
pumping144213552pum_ping
admiring1236133admiring
admixing1944133admixing
auditing1039033auditing
bemiring13239603bemiring
bemixing20226523bemixing
bumbling15249763bumbling
bumming143410783bum_ming
bumping143812493bum_ping
culicine1248343culicine
deicing11312193_deicing
demising122012523demising
dicing105718763__dicing
dumbing13319853dum_bing
dummying17263723dummying
dumping133712913dum_ping
dumpling14217893dumpling
enticing11311803enticing
fulmining1554403fulmining
fumbling16208163fumbling
fuming124013293fum__ing
guiding102911843gu_iding
guiling93214213gu_iling
guising93511413gu_ising
gumming133810193gum_ming
humbling16208673humbling
humming153310673hum_ming
humoring1456853humoring
humphing1935163humphing
humping153213073hum_ping
icing86017753___icing
immixing2043543immixing
jumbling20217233jumbling
jumping19319803jum_ping
limiting1138813limiting
lumping123314643lum_ping
macing114221553__macing
miching152911803__miching
miking134218463__miking
mimicking2043873mimicking
miming114317263__miming
mincing123314333__mincing
mining94225453__mining
miring93723803__miring
mixing164713943__mixing
mumbling15198533mumbling
mumming114010023mum_ming
mummying15263723mummying
mumping143411633mum_ping
musicking1844513musicking
mutining11310493mutining
noticing1139453noticing
numbing12269033num_bing
pacing114522753p__acing
paiking143814813p_aiking
paining103920243p_aining
pairing103716733p_airing
panicking1835293panicking
patining11312303patining
peacing124117073p_eacing
peining104619153p_eining
peising103416763p_eising
pemican1348163pemican_
pemicans1447043pemicans
periling11316863periling
picking163418333p__icking
piecing12410453p_iecing
pieing93917653p__ieing
piercing1346663piercing
piing85218833p__i_ing
piking133719643p__iking
piling95025593p__iling
pimping143812123pim_ping
pining93726533p__ining
piping114017453p__iping
placing123815283p_lacing
plaining113911553plaining
plaiting113113513plaiting
plumbing15286433plum_bing
pluming123412043plum__ing
plumping15277633plum_ping
poising103617103p_oising
pomading1437423pomading
poncing122913583p_oncing
positing11312303positing
poulticing1543403poulticing
pouncing13318883pouncing
praising113214563praising
prancing132612163prancing
premising14412413premising
premixing2157803premixing
pricking173212603p_ricking
priding113317543p_riding
priming123417373p_riming
primming15268173primming
primping15338893primping
prising103321453p_rising
prizing193514683p_rizing
promising14410973promising
pudding124010803pu_dding
puddling13218033puddling
puffing162910943pu_ffing
pugging122912543pu_gging
puking133913063pu__king
pulicene1245723pulicene
pulicide1347043pulicide
puling93621403pu__ling
pulling103821073pu_lling
pulping123612323pu_lping
pulsing103712863pu_lsing
pumice1238223pumic__e
pumiced1435173pumic_ed
pumicer1335063pumic_er
pumicers1434353pumicers
pumices1338273pumic_es
pumicites1545623pumicites
pummeling1643603pummeling
pumpkin1743523pumpkin_
pumpkins1843853pumpkins
punching163310123punching
pungling12228663pungling
punishing1545383punishing
punning103414993pu_nning
punting103318443pu_nting
pupating1337683pupating
pupping114412503pu_pping
pureeing1137273pureeing
purfling1467763purfling
purging113314183pu_rging
purifying1835853purifying
purling103620293pu_rling
purpling1368543purpling
purring104515823pu_rring
pursing103715553pu_rsing
pursuing1146233pursuing
pushing133615453pu_shing
putting103218573pu_tting
puttying1434953puttying
putzing19359123pu_tzing
puzzling19225393puzzling
quailing1838403quailing
quiring17159993qu_iring
quoining1835893quoining
quoiting1836093quoiting
remising112516453remising
remixing182810333remixing
ricing94822763__ricing
ruining83514883ru_ining
rumbaing13185303rumbaing
rumbling131910103rumbling
rumoring1136983rumoring
rumpling13178763rumpling
slicing103514643_slicing
sluicing1137063sluicing
smiling103915443_smiling
smiting103014443_smiting
spicing123914533_spicing
splicing1338963splicing
spuming1248523spum__ing
sufficing1844883sufficing
suiting83419003su_iting
summing122912383sum_ming
summiting1445793summiting
surmising1247683surmising
tricing103417353_tricing
tumbling13219293tumbling
tumescing1443643tumescing
tumping123114243tum_ping
umping114815333_um_ping
umpiring1336093_umpiring
uniting8315823_uniting
unmixing1835543unmixing
updiving1534223updiving
uppiling1335853uppiling
uprising1138953uprising
upsizing2035413upsizing
vicing124014243__vicing
voicing13279083_voicing
vomiting1437733vomiting

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621847.84318636.0
3Display Results1841840.0802300.0
 (SQL Overall)1786911848.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.