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

148 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
duncish133579(None) 
danish101513792dan_ish
donnish11187632donnish
dudish1148312du_dish
dullish1148742dullish
dumpish15116112dumpish
dunces95215752dunces_
dunch115316262dunc__h
duncishly1843012duncishly
duskish1535182duskish
hunnish1336162hunnish
nunnish1035932nunnish
punish111411502pun_ish
punkish16257692punkish
runtish1048692runtish
sunfish1338882sunfish
tundish1137282tundish
unwish1239092_unwish
banish111416043ban_ish
buckish18237883buckish
bullish12511193bullish
bunch125118603bunc__h
buncos104011593buncos_
bundist10310193bundist
burnish1238623burnish
concise11314473concise
cubbish1635803cubbish
cuish10313173cu__ish
cultish12139113cultish
currish1238353currish
dampish1567663dampish
dances95120653dances_
dancing113611563dancing
dandyish1644723dandyish
darkish1537943darkish
deafish1438533deafish
delish105215613d_elish
dentist8316743dentist
dervish1436983dervish
dish86328333d___ish
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
dovish1338103d_ovish
dronish1138913dronish
drumfish1743503drumfish
dryish1336323d_ryish
dualism1049163dualism
dualist8614053dualist
duces86327473du_ces_
duci76422623du_ci__
ducks124823213du_cks_
ducts85319893du_cts_
duelist8511413duelist
dulcify1643023dulcify
dunams937833dunams_
dunce86319263dunc__e
dunches133312583dunches
duncical1345213duncical
dunes65332173dun_es_
dungier9368583dungier
dungiest102810743dungiest
dunging103012623dunging
dungs75821973dun_gs_
dunite7315013dun_ite
dunking133813263dunking
dunks105621193dun_ks_
dunlin739723dunli_n
dunlins849553dunlins
dunness8298983dunness
dunnest83312263dunnest
dunning93514473dunning
dunnite857333dunnite
duns55140433dun__s_
dunting93418383dunting
dunts65828413dun_ts_
dutch114713823dutc__h
encash11276943_encash
finfish16268193finfish
finish124613403fin_ish
furbish1536443furbish
furnish1337383furnish
hennish1336863hennish
huffish1935713huffish
hunch136416213hunc__h
incise83515333_incise
juncos15449233juncos_
knish1238603_kn_ish
longish11229093longish
lumpish14127383lumpish
lunch104917243lunc__h
lungfish1543963lungfish
lungis77113023lungis_
mannish121710693mannish
minish115216303min_ish
minxish1936213minxish
monish114217593mon_ish
monkish1638243monkish
mudfish1646263mudfish
mulish11311903mu_lish
munch124917103munc__h
munis75022003mun_is_
noncash1245163noncash
nuncio837973nunci_o
nuncios937113nuncios
ounces83617773ounces_
outfish132210573outfish
outwish13289853outwish
panfish15229973panfish
pinfish15319303pinfish
pinkish16279113pinkish
publish1447913publish
puckish18237213puckish
puggish14265993puggish
punch125118423punc__h
punjis1536693punjis_
pupfish1735533pupfish
quackish2654383quackish
rankish14510383rankish
roundish1246253roundish
rubbish1436303rubbish
ruttish1048303ruttish
sunrise7310813sunrise
sunwise1036433sunwise
tannish101610573tannish
tonish93415903ton_ish
tonnish10149093tonnish
tunics83811263tunics_
unais53420773_unais_
uncase83817433_uncase
uncast84215713_uncast
unci65019463_unci__
uncia75015163_unci_a
unciae83215313_unciae
uncial83715223_uncial
uncini8310153_uncini
uncos74117033_uncos_
uncus74014983_uncus_
unlash938793_unlash
unmesh1145793_unmesh
unwise9510803_unwise
uppish1336633_uppish
vanish121513203van_ish
wennish1336243wennish
winish124212263win_ish
youngish1543633youngish
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 Limit1340271487.62617575.0
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.82822827.2
 
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.