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

154 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
gawkish183583(None) 
hawkish2036551hawkish
mawkish1935821mawkish
darkish1537942darkish
garfish14179202garfish
garish104516922ga_rish
garnish111610842garnish
gawkier15326522gawkier
gawkies15429122gawkies
gawkiest16327312gawkiest
gawkily1834092gawkily
gawking16398822gawking
gawkishly2342472gawkishly
gawks136811632gawk_s_
larkish1439082larkish
rakish134313962ra_kish
rankish14510382rankish
rawish123012912raw_ish
sawfish1637682sawfish
aguish1059283_aguish
ankush13114433_ankush
apish105116633_a_pish
aspish114810333_aspish
awash116613163_aw_ash
aweigh1334933_aweigh
babyish1736513babyish
baldish1339503baldish
banish111416043ba_nish
batfish1558683batfish
blackish1976713blackish
bookish163610023bookish
brackish1987613brackish
buckish18237883buckish
caddish143810123caddish
carlish12312763carlish
catfish1559023catfish
cattish12410723cattish
cockish1838503cockish
cowfish1836433cowfish
crankish1736513crankish
crawfish1944233crawfish
dampish1567663dampish
danish101513793da_nish
dawks135213493dawk_s_
duskish1535183duskish
faddish15359003faddish
fairish1338993fairish
famish14311843fa_mish
fattish1359263fattish
folkish1736563folkish
gaddis94211373gaddis_
gadis74825293ga_dis_
galosh1038553ga_losh
gash86833023ga___sh
gaskin113610583gaski_n
gasking134415913gasking
gaskins123510773gaskins
gawk126716693gawk___
gawked15468763gawk_ed
gawker14559353gawk_er
gawkers15347453gawkers
gawkiness1734753gawkiness
gawky16569993gawk__y
gawping14418463gawping
gawps115911013gaw_ps_
gawsie1038463gawsi_e
gawsy12459093gaw__sy
girlish1137193girlish
gnomish1345563gnomish
goatfish1544293goatfish
goatish1139563goatish
goodish1237963goodish
gowks136011953gowk_s_
goyish13379013g_oyish
grayfish1844483grayfish
grayish1437813grayish
greyish1435173greyish
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
hashish1238353hashish
hawkie163810093hawki_e
hawkies173311243hawkies
hawking183711423hawking
hawkishly2542753hawkishly
hawks155415703hawk_s_
hickish1936473hickish
jackfish2744123jackfish
jadish17319903ja_dish
jewfish2343543jewfish
kaddish16317973kaddish
kakis86116843ka_kis_
laddish12299723laddish
ladyish14287823ladyish
largish1138603largish
latish92416173la_tish
lavish124112983la_vish
lazyish22265853lazyish
lowish12310533low_ish
maddish14289483maddish
maidish13239553maidish
mannish121710693mannish
marish114319053ma_rish
mawkishly2442883mawkishly
monkish1638243monkish
newish1237903new_ish
oafish121311723oa_fish
oarfish13158613oarfish
owlish1238693_owlish
palish114718273pa_lish
panfish15229973panfish
parish115022353pa_rish
pawkier16236613pawkier
pawkiest17277883pawkiest
pawkily1934203pawkily
peakish16268873peakish
peckish18227293peckish
perkish16258823perkish
pinkish16279113pinkish
prankish1737023prankish
puckish18237213puckish
punkish16257693punkish
quackish2654383quackish
radish103516913ra_dish
raffish1658843raffish
rakis95323443ra_kis_
rammish1437563rammish
raspish1298103raspish
ratfish1338773ratfish
rattish10510823rattish
ravish123414033ra_vish
sakis95323663sa_kis_
saltish10312163saltish
sickish1638423sickish
sparkish17276973sparkish
swish115114823_sw_ish
tallish103313583tallish
tannish101610573tannish
tarnish101611873tarnish
tartish101512633tartish
townish13167933townish
unwish1239093unw_ish
vampish1766283vampish
vanish121513203va_nish
varnish13169533varnish
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
warmish1538373warmish
waspish1586923waspish
weakish17217173weakish
whish144512923__whish
wish107228733__w_ish
zanyish2235903zanyish

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271547.48617903.7
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.70523191.6
 
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.