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

135 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
piggish1422770(None) 
biggish14247501biggish
jiggish19225941jiggish
pigfish16217171pigfish
priggish1544681priggish
puggish14265991puggish
boggish14238652boggish
doggish13237532doggish
haggish15207472haggish
hoggish15247592hoggish
loggish12258722loggish
piggie103210772piggi_e
piggier113510002piggier
piggies113813482piggies
piggiest12259662piggiest
piggin103111092piggi_n
pigging123614672pigging
piggins113010472piggins
piggishly1942722piggishly
pinfish15319302pinfish
pinkish16279112pinkish
pixyish2253652pixyish
priggism1444382priggism
tigrish1137572tigrish
waggish15207072waggish
woggish15276672woggish
aguish1059283_aguish
anguish11117633anguish
biggest1138143biggest
biggie103810933biggi_e
biggies113813523biggies
biggin103710603biggi_n
bigging122815883bigging
biggins113410693biggins
biggity1435013biggity
digging113513703digging
dogfish15226763dogfish
dreggish1453133dreggish
english1137953english
figging133313563figging
finfish16268193finfish
finish124613413fi_nish
fogyish1735363fogyish
gigging93311773gigging
girlish1137193girlish
hagfish17227613hagfish
haggis11209513haggis_
hickish1936473hickish
hippish1736183hippish
hogfish17257023hogfish
igging93212073_igging
iggs66612673_igg_s_
impish13499193_impish
jiggier16377823jiggier
jiggiest17277693jiggiest
jigging173011553jigging
jingoish19134383jingoish
kiddish16276583kiddish
kingfish1944493kingfish
largish1138603largish
lightish1556623lightish
longish11229093longish
miggs96311373migg_s_
minish115216303mi_nish
minxish1936213minxish
ogrish1039263_ogrish
paganish1447773paganish
palish114718273p_alish
panfish15229973panfish
parish115022353p_arish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
pegging122811133pegging
perish114619063p_erish
perkish16258823perkish
pettish1238283pettish
pianism11611033pianism
pianist9615103pianist
pidgin10259813pidgi_n
pidgins11259123pidgins
pietism1139113pietism
pietist9414033pietist
pigfishes1845003pigfishes
pigged114214153pigg_ed
piggery14266193piggery
pigginess1375453pigginess
piggy124011433pigg__y
piglike14157313piglike
pigmies122610993pigmies
pignus937953pignus_
pigs76634223pi_g_s_
pikis115116393pi_kis_
pilis75825203pi_lis_
pinging113419553pinging
pingos95317673pingos_
pings85830883ping_s_
pipefish1844533pipefish
pish96127913p___ish
pixieish2042603pixieish
planish12412053planish
plenish1239943plenish
polish114916723p_olish
poorish123712303poorish
popish133812113p_opish
prigging13299093prigging
priggishly2051753priggishly
priggisms1543253priggisms
prudish1376563prudish
publish1447913publish
puckish18237213puckish
puggier11309383puggier
puggiest12219223puggiest
pugging122912543pugging
punish111411503p_unish
punkish16257693punkish
pupfish1735533pupfish
pygmyish2241343pygmyish
rigging103016333rigging
roguish1156833roguish
sickish1638423sickish
sluggish1344773sluggish
thuggish1642653thuggish
tigerish1246563tigerish
vigorish1545173vigorish
voguish1465203voguish
widish13419363wi_dish
wiggier12418863wiggier
wiggiest13269013wiggiest
wigging133413833wigging
wildish1446853wildish
wimpish1765693wimpish
winish124212263wi_nish
wispish1575643wispish
zigging193210533zigging

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271355.76623244.4
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.21828737.7
 
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.