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

151 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
biggish1424750(None) 
boggish14238651boggish
jiggish19225941jiggish
piggish14227701piggish
biggest1138142biggest
biggie103810932biggi_e
biggies113813522biggies
biggin103710602biggi_n
bigging122815882bigging
biggins113410692biggins
biggity1435012biggity
doggish13237532doggish
haggish15207472haggish
hoggish15247592hoggish
loggish12258732loggish
pigfish16217172pigfish
priggish1544682priggish
puggish14265992puggish
tigrish1137572tigrish
waggish15207072waggish
woggish15276672woggish
aguish1059283_aguish
anguish11117633anguish
babyish1736513babyish
baggie102912193baggi_e
baggier113611643baggier
baggies113814853baggies
baggiest123011753baggiest
baggily1436043baggily
bagging123316983bagging
bairnish1345473bairnish
baitfish1645483baitfish
baldish1339503baldish
banish111416063b_anish
batfish1558683batfish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
begging123012653begging
bialis83617163bialis_
biblist11310833biblist
bidis86721153bi_dis_
bigamist1347063bigamist
bigger104315063bigg_er
biggety1434433biggety
biggings13327473biggings
biggy124413133bigg__y
bights124417963bights_
bigness1038193bigness
bigos85020013bi_gos_
bigots95015133bigots_
bigs76235033bi_g_s_
bigtime1235753bigtime
bigwig1333343bigwi_g
bigwigs1443003bigwigs
bilges94915633bilges_
bilgier10358533bilgier
bilgiest11309883bilgiest
bilging114212683bilging
billfish1645033billfish
bindis94614583bindis_
binges93923123binges_
binging113619383binging
bingos95514793bingos_
biogas94310913biogas_
biogs85016113biog_s_
blemish1436603blemish
blimpish1743723blimpish
blueish1236483blueish
bluish1159243b_luish
boarish123911913boarish
boggier113711583boggier
boggiest123110933boggiest
bogging123615753bogging
bogyism1545213bogyism
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233b_oyish
brightish1863663brightish
brinish1239963brinish
broguish1444103broguish
brutish1237703brutish
buckish18237883buckish
buggier113611343buggier
buggies114613813buggies
buggiest123410363buggiest
bugging123515183bugging
bullish12511193bullish
burnish1238623burnish
digging113513703digging
dogfish15226763dogfish
dreggish1453133dreggish
english1137953english
figging133313563figging
finfish16268193finfish
finish124613423fi_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_
minish115216313mi_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
winish124212273wi_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 Limit1340271516.51320578.4
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.98225593.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.