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

259 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
longish1122909(None) 
loggish12258721loggish
blondish1476172blondish
boggish14238652boggish
doggish13237532doggish
donnish11187632donnish
hoggish15247592hoggish
languish12136252languish
largish1138602largish
lionfish1454092lionfish
longes75925572longes_
longest84114952longest
longies82916552longies
longing93915782longing
longs65527062long_s_
longwise1244082longwise
loudish1137982loudish
loutish1039962loutish
lowish12310532lo_wish
lungfish1543962lungfish
lungis77113022lungis_
monish114217592mon_ish
monkish1638242monkish
tonish93415902ton_ish
tonnish10149092tonnish
woggish15276672woggish
youngish1543632youngish
anguish11117633_anguish
banish111416043ban_ish
biggish14247503biggish
blandish1497003blandish
blockish19115793blockish
blowfish1944703blowfish
boarish123911913boarish
bonefish1646283bonefish
bonging113316373bonging
bongoist1147643bongoist
bongos95316653bongos_
bongs87828423bong_s_
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
clannish1345263clannish
clingfish1842973clingfish
cloddish1544233cloddish
clonism1138983clon_ism
clownish1643803clownish
cockish1838503cockish
codfish1637163codfish
cognise1059683cognise
coldish1399303coldish
coltish121310933coltish
concise11314473concise
congas94417033congas_
conges94928173conges_
congest104618773congest
congii957363congi_i
congius103210073congius
congos94219883congos_
consist9316033consist
coolish12312523coolish
corgis9314403corgis_
cowfish1836433cowfish
coyish143710393co_yish
cronish12310863cron_ish
danish101513793dan_ish
dogfish15226763dogfish
dollish11610093dollish
doltish11118733doltish
dongas84914613dongas_
dongs76525813dong_s_
dovish1338103do_vish
dronish1138913dron_ish
duncish1335793duncish
english1137953_english
eonism83213533eon_ism
finfish16268193finfish
finish124613403fin_ish
flongs105010493flong_s_
flourish1446753flourish
fogyish1735363fogyish
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
gnomish1345563gnomish
goatish1139563goatish
gonging103713033gonging
gongs74921613gong_s_
goodish1237963goodish
goyish13379013go_yish
haggish15207473haggish
hennish1336863hennish
hogfish17257023hogfish
hongi96715853hongi__
hongied12308163hongied
hongies112716473hongies
hongs95126203hong_s_
hottish13117893hottish
hunnish1336163hunnish
ionise63516933ion_ise
jiggish19225943jiggish
jingoish19134373jingoish
kingfish1944483kingfish
klongs11436603klong_s_
knish1238603_kn_ish
laddish12299723laddish
ladyish14287823ladyish
lanais6316793lanais_
larkish1439083larkish
latish92416173l_atish
lavish124112983l_avish
lazyish22265853lazyish
leftish13197253leftish
legist71315253l_egist
lemonish1347313lemon_ish
length1046103leng_th
lengths1144083lengths
lenis56326863len_is_
lentisk1136063lentisk
lingas75116563lingas_
lingier84113373lingier
lingiest93715243lingiest
lings67135773ling_s_
linguisa944473linguisa
linguist948573linguist
lionise7310373lion_ise
locoism1156793locoism
lodges86820143lodges_
lodging103110813lodging
loges66534203lo_ges_
loggia8457053loggi_a
loggias9356783loggias
loggie84011993loggi_e
loggier93811143loggier
loggiest103011013loggiest
logging103316803logging
logia68116603lo_gi_a
logic88217833lo_gi_c
logics95711123lo_gics
logier75015733lo_gier
logiest82515543lo_giest
logily1039833lo_gily
login66025003lo_gi_n
logins77820643lo_gins
logion76013723lo_gion
logos67225333lo_gos_
logs57343113lo_g_s_
loners64225803loners_
long56933343long___
longan75612363long_an
longans84510813longans
longbow1343863longbow
longe66626463long__e
longed87121373long_ed
longeing10177593longeing
longer75823193long_er
longers84819533longers
longings10408563longings
longline938763longline
longly10279603long_ly
longness938543longness
longship1444093long_ship
longtime1144363longtime
lookism1335913lookism
lookist1139563lookist
loris55329153lo_ris_
lough95118483loug__h
loughs105014773loughs_
louis57322323lo_uis_
lounges84811353lounges_
lounging1036753lounging
lumpish14127383lumpish
lunges76123423lunges_
lungi65516053lungi__
lunging93714213lunging
lungs65223883lung_s_
lungyis11294103lungyis_
mannish121710693mannish
minish115216293min_ish
minxish1936213minxish
mobbish1635923mobbish
modish123813543mo_dish
mongos94318623mongos_
mongst93512603mong_st
monism104016313mon_ism
monist84324983mon_ist
monkfish2044003monkfish
moonfish1675333moonfish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
noirish1037883noirish
noncash1245163noncash
nourish1039703nourish
nunnish1035933nunnish
oafish121311723_oafish
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
oldish10169313_oldish
ologist8313833ologist
onrush935343_onrush
orangish1246543orangish
owlish1238693_owlish
panfish15229973panfish
piggish14227703piggish
pinfish15319303pinfish
pinkish16279113pinkish
planish12412053plan_ish
plenish1239943plen_ish
polish114916723po_lish
pongid104111583pongi_d
pongids11347413pongids
ponging113416153ponging
pongs85526343pong_s_
poorish123712303poorish
popish133812113po_pish
puggish14265993puggish
punish111411503pun_ish
punkish16257693punkish
rankish14510383rankish
roguish1156833roguish
rompish1436693rompish
roughish1545213roughish
roundish1246253roundish
runtish1048693runtish
slobbish1544263slobbish
slowish1337633slo_wish
sluggish1344773sluggish
softish13127813softish
songs67725553song_s_
sottish10129433sottish
sourish10310693sourish
stonish10410653ston_ish
strongish1344923strongish
sunfish1338883sunfish
tannish101610573tannish
toadish1139063toadish
tongas74315513tongas_
tonging93314513tonging
tongs65928463tong_s_
toughish1545283toughish
townish13167933townish
toyish122911123to_yish
tundish1137283tundish
unwish1239093_unwish
vanish121513203van_ish
voguish1465203voguish
waggish15207073waggish
wennish1336243wennish
winish124212263win_ish
wolfish1636933wolfish
wormish1537163wormish
yogis95617743yo_gis_
yonis85020823yon_is_
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.1601116818.8
2DLD Change Limit1340272597.68617437.8
3Display Results2592590.0932784.9
 (SQL Overall)1786912597.93922508.0
 
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.