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

144 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
punisher133577(None) 
punished1436041punished
punishers1434971punishers
punishes1338111punishes
banisher13169182banisher
burnisher1444822burnisher
finisher1436302finisher
furnisher1544522furnisher
pisher114317752p__isher
planisher1495852planisher
polisher1388072polisher
publisher1644212publisher
puncher143311672pun_cher
punier84519222puni__er
punish111411502punish__
punster92911102pun_ster
pusher114318282pu__sher
vanisher14167452vanisher
banished14189063banished
banishers14258053banishers
banishes131812463banishes
banister10199973banister
burnished1544923burnished
burnishers1543703burnishers
burnishes1436643burnishes
busher114922203bu__sher
canister101710853canister
cuishes122810823cu_ishes
danishes121710493danishes
finished1536483finished
finishers1545353finishers
finishes1438983finishes
fisher124917143__fisher
furbisher1743703furbisher
furnished1644583furnished
furnishers1643633furnishers
furnishes1536233furnishes
ganister9178993ganister
garnisher13195853garnisher
gusher104115773gu__sher
juniper1634023juni_per
knishes1438263_knishes
lavisher1445083lavisher
luncher123111413lun_cher
lunier64617603luni__er
lusher93818763lu__sher
minished1437873minished
minishes13310583minishes
minister10410363minister
monished1438133monished
monishes13311483monishes
muncher143610373mun_cher
munster93710523mun_ster
musher113820573mu__sher
nigher103612753__nigher
nosher94616363__nosher
nourisher1274483nourisher
panfishes1737593panfishes
panier84425503pani__er
panther12611443pan_ther
parishes13314753parishes
paviser12489093pavis_er
penises9318193penis_es
penster92811953pen_ster
perished14310083perished
perishes13313753perishes
pinaster1037113pinaster
pincher143812713pin_cher
pinfishes1746243pinfishes
pinier84024693pini__er
pinscher1544803pinscher
pished124817063p__ished
pishers123815753p__ishers
pishes114722103p__ishes
pisser84416383p__isser
plaister1068013plaister
planished1566123planished
planishers1584773planishers
planishes14138523planishes
plasher124215033p_lasher
plenished1584953plenished
plenishes1487083plenishes
plusher124010383p_lusher
poiser84217243p_ois_er
polished1468433polished
polishers1477603polishers
polishes13711783polishes
posher115018163p__osher
praiser93413943prais_er
published1744343published
publishers1743523publishers
publishes1645933publishes
puisne856353pu_isne_
puisnes937423pu_isnes
pulser84215193pu_ls_er
pumicer1335063pumi_cer
punched153512173pun_ched
punchers152610073pun_chers
punches144816133pun_ches
punchier1536413punchier
punishing1545383punishing
punishment1754543punishment
punker123718823pun__ker
punkier133512793pun_kier
punkish16257693punkish__
punner84918153pun__ner
punnier93511263pun_nier
punsters103310583pun_sters
punter84320023pun__ter
pupfishes1944313pupfishes
purifier1338573purifier
purser85020473pu_rs_er
pursier94012753pu_rsier
pursuer9338893pu_rsuer
pushed125017463pu__shed
pushers123814503pu__shers
pushes114621663pu__shes
pushier123611093pu__shier
pussier93711993pu_ssier
quasher19198623qu_asher
ravisher1465463ravisher
rusher94019653ru__sher
sinister838583sinister
sunfishes1547033sunfishes
swisher13369523_swisher
tundishes1344543tundishes
unfished15218293_unfished
unifier102211863_unifier
uniquer1675783_uniquer
unisex1358353_unis_ex
uniter64619143_uni_ter
unkosher1573763_unkosher
unpunished1642523unpunished
unshed10313773_un_shed
unwiser1037123_unwis_er
unwished15237833_unwished
unwishes14147483_unwishes
upriser9218763upris_er
usher84517763_u__sher
vanished15207743vanished
vanishers15186613vanishers
vanishes141610753vanishes
varnisher15195403varnisher
wisher123617063__wisher

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.406440125.6
2DLD Change Limit1461621447.30020022.2
3Display Results1441440.0433348.8
 (SQL Overall)1786911447.74923059.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.