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

147 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
punished143604(None) 
punisher1335771punisher
punishes1338111punishes
banished14189072banished
burnished1544922burnished
finished1536482finished
furnished1644582furnished
minished1437872minished
monished1438132monished
perished14310092perished
pished124817062p__ished
planished1566122planished
plenished1584952plenished
polished1468432polished
published1744342published
punched153512172pun_ched
punish111411512punish__
punishers1434972punishers
pushed125017462pu__shed
unfished15218292_unfished
unpunished1642522unpunished
unshed10313772_un_shed
unwished15237832_unwished
vanished15207762vanished
aniseed839403_aniseed
banisher13169193banisher
banishes131812473banishes
bunched154312413bun_ched
burnisher1444823burnisher
burnishes1436643burnishes
bushed124822383bu__shed
cuishes122810823cu_ishes
danishes121710503danishes
dished114318713__dished
enisled82510223_enisled
evanished1644333evanished
famished1766023famished
finisher1436303finisher
finishes1438983finishes
fished134316313__fished
furbished1843773furbished
furnisher1544523furnisher
furnishes1536233furnishes
garnished14196143garnished
gnashed12317523_gnashed
guised84612173gu_is_ed
gushed114816243gu__shed
hunched163710493hun_ched
hushed134416673hu__shed
ionised82911493ionis_ed
knishes1438263_knishes
lavished1555133lavished
lunched133911823lun_ched
lushed104218723lu__shed
minishes13310583minishes
monishes13311483monishes
munched153411073mun_ched
mushed124420843mu__shed
niched125514063__niched
nighed113811293__nighed
noshed104413513__noshed
nourished1374613nourished
outfished16116603outfished
outwished1655683outwished
panfishes1737593panfishes
panicked1785173panicked
panicled13106783panicled
parishes13314763parishes
pashed125923143p__ashed
paunched1645523paun_ched
peised94817683p_eis_ed
penises9318193penis_es
perishes13313753perishes
pinched153812453pin_ched
pinfishes1746243pinfishes
pinioned1137513pinioned
pisher114317753p__isher
pishes114722103p__ishes
pissed94816933p__issed
pithed124615613p__ithed
planisher1495853planisher
planishes14138523planishes
plashed133712643p_lashed
plenishes1487083plenishes
poised94918473p_ois_ed
polisher1388073polisher
polishes13711783polishes
ponied94920703poni__ed
praised104214813prais_ed
prised94322203p_ris_ed
prissed103311263p_rissed
publisher1644213publisher
publishes1645933publishes
puisne856353pu_isne_
puisnes937423pu_isnes
pulsed94013723pu_ls_ed
pumiced1435173pumi_ced
puncher143311673pun_cher
punches144816133pun_ches
pungled114210083pun_gled
punier84519233puni__er
punishing1545383punishing
punishment1754543punishment
punkish16257693punkish__
punned93416193pun__ned
punster92911103pun_ster
punted94618713pun__ted
pupfishes1944313pupfishes
purified1438743purified
pursed95220883pu_rs_ed
pursued10388133pu_rsued
pusher114318283pu__sher
pushes114621663pu__shes
quashed20207983qu_ashed
quinsied1845043quinsied
ravished1555713ravished
relished1239433relished
rushed104419863ru__shed
squished21186393squished
stonished1345593stonished
sunfishes1547033sunfishes
swished14418843_swished
tarnished13196063tarnished
tundishes1344543tundishes
tushed104615893tu__shed
unasked122010023_unasked
uncashed14299763_uncashed
unified112413573_unified
unisex1358353_unis_ex
unissued934683_unissued
united74421543_uni_ted
unkissed1334893_unkissed
unlashed12289183_unlashed
unlisted9311153_unlisted
unmeshed1437003_unmeshed
unrushed12247573_unrushed
unshod1067603_un_shod
unsized172510543_unsized
unused72012883_unus_ed
unwashed15288483_unwashed
unwishes14147483_unwishes
uprushed14234473uprushed
vanisher14167473vanisher
vanishes141610773vanishes
varnished16195613varnished
whished17428023_whished
wished134417513__wished

Search took 8 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.470380193.6
2DLD Change Limit1461621477.21620255.3
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.73223110.6
 
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.