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 “paunchier” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
paunchier164333(None) 
punchier1536411p_unchier
raunchier1443711raunchier
bunchier1536152_bunchier
crunchier1644682crunchier
launcher1365562launch_er
patchier15319662pa_tchier
paunched1645522paunch_ed
paunches1568172paunch_es
paunchiest1743852paunchiest
pouchier1546802pou_chier
puncher143311672p_unch_er
achier113914263_a__chier
auntlier834903_auntlier
bouncier1236033bounc_ier
branchier1637133branchier
bruncher15347783brunch_er
catchier15329863ca_tchier
chinchier1944633chinchier
churchier1944153churchier
cruncher15338073crunch_er
fancier123412063fa_nc_ier
gaucher1337233gau_ch_er
haunched1744813haunch_ed
haunches1656963haunch_es
jauntier1535233jaun_tier
jouncier1734423jounc_ier
launched1475403launch_ed
launchers1454333launch_ers
launches1387903launch_es
launching1544783launching
luncher123111413_lunch_er
muncher143610373_munch_er
munchies1539253_munchies
pacier105018683pa__c_ier
painches1588913painch_es
paintier1048793pain_tier
panickier1743173panickier
panier84425503pa_n__ier
pannier93613353pa_n_nier
panther12611443pa_nth_er
patcher143515143pa_tch_er
paunch13369853paunch___
paunchiness1842343paunchiness
paunchy17324443paunch__y
peachier1548623p_eachier
pincher143812713p_inch_er
pitchier15368273p_itchier
pluckier16295073plu_ckier
plunkier14305323plun_kier
plushier1375193plu_shier
poachier1556823p_oachier
pouncer113511233pounc__er
preachier1646923preachier
punched153512173p_unch_ed
punchers152610073p_unch_ers
punches144816133p_unch_es
punchiest1636453p_unchiest
punchily1844863p_unchily
punching163310123p_unching
punier84519223p_un__ier
punkier133512793p_un_kier
punnier93511263p_un_nier
pushier123611093p_u_shier
rancher123013633ra_nch_er
raunches1368053raunch_es
raunchiest1543933raunchiest
raunchily1742813raunchily
saucier9810283sau_c_ier
smutchier1643503smutchier
stauncher1443513staunch_er
stenchier1445333stenchier
touchier1347383tou_chier

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.440406115.9
2DLD Change Limit148641737.15620771.5
3Display Results73730.0302433.3
 (SQL Overall)178691737.62623431.8
 
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.