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

108 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
punishers143497(None) 
punisher1335771punisher_
punishes1338111punishe_s
banishers14258052banishers
burnishers1543702burnishers
finishers1545352finishers
furnishers1643632furnishers
pishers123815752p__ishers
planishers1584772planishers
polishers1477602polishers
publishers1743522publishers
punchers152610072pun_chers
punished1436042punishe_d
punsters103310582pun_sters
pushers123814502pu__shers
vanishers15186612vanishers
banisher13169183banisher_
banishes131812463banishe_s
banisters11189473banisters
burnisher1444823burnisher_
burnishes1436643burnishe_s
bushers124018803bu__shers
canisters112310193canisters
cuishes122810823cu_ishe_s
danishes121710493danishe_s
finisher1436303finisher_
finishes1438983finishe_s
fishers134714723__fishers
furbishers1843093furbishers
furnisher1544523furnisher_
furnishes1536233furnishe_s
ganisters10248313ganisters
garnishers14174863garnishers
gushers113512513gu__shers
junipers1733933juni_pers
knishes1438263_knishe_s
lavishers1564643lavishers
lunchers13349563lun_chers
minishes13310583minishe_s
ministers1139623ministers
monishes13311483monishe_s
munchers15318773mun_chers
munsters104010553mun_sters
mushers124016443mu__shers
noshers103614333__noshers
nourishers1383633nourishers
panfishes1737593panfishe_s
paniers94717333pani__ers
panthers13510783pan_thers
parishes13314753parishe_s
pavisers13387443pavis_ers
penises9318193penis_e_s
pensters103012123pen_sters
perishes13313753perishe_s
pinasters1136823pinasters
pinchers153510613pin_chers
pinfishes1746243pinfishe_s
pinschers1644373pinschers
pisher114317753p__isher_
pishes114722103p__ishe_s
pissers95014753p__issers
plaisters1137813plaisters
planisher1495853planisher_
planishes14138523planishe_s
plashers133813453p_lashers
plenishes1487083plenishe_s
poisers94214433p_ois_ers
polisher1388073polisher_
polishes13711783polishe_s
praisers103410833prais_ers
publisher1644213publisher_
publishes1645933publishe_s
puisnes937423pu_isne_s
pulsers94213153pu_ls_ers
pumicers1434353pumi_cers
puncher143311673pun_cher_
punches144816133pun_che_s
punier84519223puni__er_
puniness101610273puni_ness
punish111411503punish___
punishing1545383punishing
punishment1754543punishment
punishments1853443punishments
punkers133714853pun__kers
punners94114233pun__ners
punster92911103pun_ster_
punters93617043pun__ters
pupfishes1944313pupfishe_s
purifiers1435873purifiers
pursers93916093pu_rs_ers
pursuers10376523pu_rsuers
pusher114318283pu__sher_
pushes114621663pu__she_s
quashers20186803qu_ashers
ravishers1564783ravishers
rushers103816103ru__shers
sunfishes1547033sunfishe_s
swishers14328053_swishers
tundishes1344543tundishe_s
unifiers11237173_unifiers
uniters73814173_uni_ters
unwishes14147483_unwishe_s
uprisers10206773upris_ers
ushers94415533_u__shers
vanisher14167453vanisher_
vanishes141610753vanishe_s
varnishers16174343varnishers
wishers133215213__wishers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411086.56322648.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.03225411.1
 
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.