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

179 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
doggish1323753(None) 
boggish14238651boggish
dogfish15226761dogfish
hoggish15247591hoggish
loggish12258721loggish
woggish15276671woggish
biggish14247502biggish
doggie93910892doggi_e
doggier103810942doggier
doggies103613022doggies
doggiest113410522doggiest
dogging113312692dogging
doggishly1842892doggishly
dollish11610092dollish
doltish11118732doltish
donnish11187632donnish
dovish1338102do_vish
dreggish1453132dreggish
fogyish1735362fogyish
haggish15207472haggish
hogfish17257022hogfish
jiggish19225942jiggish
longish11229092longish
ogrish1039262_ogrish
piggish14227702piggish
puggish14265992puggish
roguish1156832roguish
voguish1465202voguish
waggish15207072waggish
aguish1059283_aguish
anguish11117633anguish
boarish123911913boarish
boggier113711583boggier
boggiest123110933boggiest
bogging123615753bogging
bogyism1545213bogyism
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
broguish1444103broguish
cockish1838503cockish
codfish1637163codfish
cogging123513713cogging
cognise1059683cognise
coldish1399303coldish
coltish121310933coltish
coolish12312523coolish
corgis9314403corgis_
cowfish1836433cowfish
coyish143710393co_yish
daggas937973daggas_
dampish1567663dampish
danish101513793d_anish
darkish1537943darkish
deafish1438533deafish
delish105215613d_elish
dervish1436983dervish
digging113513703digging
dish86328333d___ish
dodges96119073dodges_
dodgier10388243dodgier
dodgiest11308713dodgiest
dodging11299063dodging
dodoism1135893dodoism
doges75630163do_ges_
dogeys115510663dogeys_
dogfight1742993dogfight
dogfishes1745083dogfishes
dogged106017703dogg_ed
dogger95216783dogg_er
doggers104413433doggers
doggery13448263doggery
doggo84410703dogg__o
doggone1035683doggone
doggrel1033883doggrel
doggy115214873dogg__y
dogie75222793do_gi_e
dogies85022253do_gies
doglike13207453doglike
dogmas105011243dogmas_
dogs66440153do_g_s_
dongas84914613dongas_
dongs76525813dong_s_
dough105217383doug__h
doughs115912933doughs_
dowdyish1952833dowdyish
dronish1138913dronish
druggist11163663druggist
dryish1336323d_ryish
dudish1148313d_udish
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
english1137953english
fogeyish1843843fogeyish
foggier12349913foggier
foggiest13249653foggiest
foggily1535053foggily
fogging133513733fogging
fogyism1643943fogyism
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
frogfish1843943frogfish
goatish1139563goatish
goodish1237963goodish
goyish13379013go_yish
hagfish17227613hagfish
haggis11209513haggis_
hogging133112803hogging
hoggishly2042953hoggishly
hoggs107212463hogg_s_
hogwash1742703hogwash
hottish13117893hottish
jogging173211233jogging
largish1138603largish
loggia8457053loggi_a
loggias9356783loggias
loggie84011993loggi_e
loggier93811143loggier
loggiest103011013loggiest
logging103316803logging
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
mobbish1635923mobbish
modish123813543mo_dish
moggie103210103moggi_e
moggies113111723moggies
mogging123311493mogging
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
noggin8288883noggi_n
nogging103612723nogging
noggins9288453noggins
noggs75811183nogg_s_
noirish1037883noirish
nourish1039703nourish
oafish121311723_oafish
oddish11107653_oddish
offish15137273_offish
ogreish1134673_ogreish
ogrism937913_ogrism
oldish10169313_oldish
owlish1238693_owlish
pigfish16217173pigfish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
priggish1544683priggish
rompish1436693rompish
roughish1545213roughish
sluggish1344773sluggish
softish13127813softish
soggier93410883soggier
soggiest102711643soggiest
soggily1235953soggily
sottish10129433sottish
sourish10310693sourish
thuggish1642643thuggish
tigrish1137563tigrish
toadish1139063toadish
togging103512743togging
tonish93415903to_nish
tonnish10149093tonnish
toughish1545283toughish
townish13167933townish
toyish122911123to_yish
wolfish1636933wolfish
wormish1537163wormish
yogis95617743yo_gis_
youngish1543633youngish

Search took 9 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.296603685.8
2DLD Change Limit1340271798.47015823.7
3Display Results1791790.0632841.3
 (SQL Overall)1786911798.82920239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.