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 “jiggish” 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
jiggish1922594(None) 
biggish14247501biggish
piggish14227701piggish
boggish14238652boggish
doggish13237532doggish
haggish15207472haggish
hoggish15247592hoggish
jiggier16377822jiggier
jiggiest17277692jiggiest
jigging173011552jigging
jingoish19134382jingoish
loggish12258722loggish
pigfish16217172pigfish
priggish1544682priggish
puggish14265992puggish
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
jadish17319903j_adish
jaggier16339183jaggier
jaggies163311083jaggies
jaggiest17289323jaggiest
jagging173311993jagging
jaggs148111493jagg_s_
jewfish2343543jewfish
jigged164412773jigg_ed
jigger155313053jigg_er
jiggers164010183jiggers
jiggle153811993jigg_le
jiggled17358843jiggled
jiggles164111433jiggles
jigglier1754093jigglier
jiggliest1854183jiggliest
jiggling18226363jiggling
jiggly18378713jigg_ly
jiggy17549143jigg__y
jiglike19105333jiglike
jigs126524763ji_g_s_
jingoism18123943jingoism
jingoist16126263jingoist
jinnis13489053jinnis_
jogging173211233jogging
jugging172910723jugging
kiddish16276583kiddish
kingfish1944493kingfish
largish1138603largish
lightish1556623lightish
longish11229093longish
miggs96311373migg_s_
minish115216303mi_nish
minxish1936213minxish
ogrish1039263_ogrish
piggie103210773piggi_e
piggier113510003piggier
piggies113813483piggies
piggiest12259663piggiest
piggin103111093piggi_n
pigging123614673pigging
piggins113010473piggins
piggishly1942723piggishly
pinfish15319303pinfish
pinkish16279113pinkish
pixyish2253653pixyish
priggism1444383priggism
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 Limit1340271085.75023309.0
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.20228811.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.