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

267 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
elfish126796(None) 
elvish1277561elvish
selfish1388511selfish
bluish1159242bluish
deafish1438532deafish
dealfish1545502dealfish
delish105215612del_ish
elfin84312462elfi_n
elfins94810942elfins
elfishly1743502elfishly
fish106926272__fish
fluish1239332fluish
hellish13310722hellish
jewfish2343542jewfish
leftish13197252leftish
oafish121311722oafish
offish15137272offish
oldish10169312oldish
redfish1437792redfish
relish93916952rel_ish
serfish1348972serfish
wolfish1636932wolfish
aguish1059283aguish
alfas87219043alfas_
alifs86121263alifs_
alist56136783al_ist
angelfish1642863angelfish
apish105116633_apish
aspish114810333aspish
baldish1339503baldish
banish111416043banish
batfish1558683batfish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
billfish1645033billfish
blemish1436603blemish
bliss75616913bl_iss
blowfish1944703blowfish
bluefish1645143bluefish
blueish1236483blueish
blush105115313bl_ush
boxfish2285543boxfish
boyish142911233boyish
bullish12511193bullish
catfish1559023catfish
cellist9314423cellist
clash106219033cl_ash
clayish1547943clayish
coalfish1635493coalfish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
cowfish1836433cowfish
coyish143710393coyish
cuish10313173_cuish
cultish12139113cultish
danish101513793danish
defis96717503defis_
delfs94918673delf_s_
delfts10439673delfts_
delis64928543del_is_
delist74625053del_ist
dervish1436983dervish
devilfish1942323devilfish
dish86328333__dish
dogfish15226763dogfish
dollish11610093dollish
doltish11118733doltish
dovish1338103dovish
dryish1336323dryish
dudish1148313dudish
dullish1148743dullish
effigy1642213effigy
effs105114033e_ffs_
effuse1234963effuse
efs66829603e_f_s_
efts76519483e_fts_
egis56520653e_gis_
egoism977473egoism
egoist7612283egoist
elain55324703elai_n
elains64919853elains
elans55527753elans_
elapse857523elapse
eldest72912683eldest
eldrich1354583eldrich
elds56324853el_ds_
elegise8139393elegise
elegist81311973elegist
elemis8312383elemis_
elf66138523elf___
elflike1435133elflike
elhi7612403elhi__
elide64922643el_ide
elint55436473el_int
elite56230183el_ite
elitism939763elitism
elitist7414913elitist
elks85820033el_ks_
ellipse944013ellipse
ells46431353el_ls_
elmier839813elmier
elmiest9310743elmiest
elms67322703el_ms_
eloign7456983eloign
eloin55923203eloi_n
eloins65419383eloins
els37645723el__s_
else45923083el__se
elves85118743elves_
elvishly1743313elvishly
emdash12244113emdash
encash11276943encash
endash10297123endash
english1137953english
enlist6417043enlist
enmesh1134893enmesh
enrich1138943enrich
eolith93013903eolith
eonism83213533eonism
etuis54013133etuis_
evanish1337653evanish
excise1538553excise
exist124618943e_xist
fallfish1744463fallfish
famish14311843famish
fash107232293__fash
fetish12310373fetish
filefish1745593filefish
finfish16268193finfish
finish124613403finish
fisc96819753__fisc
fishy146011663__fishy
fist76248423__fist
flash115716213fl_ash
flatfish1744933flatfish
flemish1536373flemish
flesh115013743fl_esh
flush115116073fl_ush
folkish1736563folkish
foolfish1744393foolfish
foxfish2354483foxfish
garfish14179203garfish
garish104516923garish
goldfish1644203goldfish
goyish13379013goyish
hagfish17227613hagfish
headfish1845443headfish
heimish1535463heimish
hennish1336863hennish
hogfish17257023hogfish
huffish1935713huffish
impish13499173impish
jadish17319903jadish
jellyfish2551903jellyfish
jewelfish2551703jewelfish
knish1238603_knish
kufis1249253kufis_
laich105920713_laich
laigh95515923_laigh
laith85722103_laith
lash76539653_l_ash
latish92416173latish
lavish124112983lavish
leash85519213_leash
leftism12226093leftism
leftist10279353leftist
lefts86517813lefts_
legist71315253legist
leis45739603_leis_
lenis56326863lenis_
levis85818553levis_
lewis85315843lewis_
lexis125916033lexis_
lich96230843_l_ich
lis37162273_l_is_
lisp68926873_l_isp
list47055343_l_ist
lowish12310533lowish
lush75327693_l_ush
marish114319053marish
milkfish2043333milkfish
minish115216293minish
modish123813543modish
monish114217593monish
mopish134311593mopish
mudfish1646263mudfish
mulish11311903mulish
nebbish1444253nebbish
nerdish1137103nerdish
newish1237903newish
oarfish13158613oarfish
oddish11107653oddish
ogrish1039263ogrish
outfish132210573outfish
overfish1737893overfish
owlish1238693owlish
palish114718273palish
panfish15229973panfish
parish115022353parish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
pelfs105016293pelf_s_
pelvis113610323pelvis_
perish114619063perish
perkish16258823perkish
pettish1238283pettish
pigfish16217173pigfish
pinfish15319303pinfish
pish96127913__pish
planish12412053planish
plash104616563pl_ash
plenish1239943plenish
plush105614713pl_ush
polish114916723polish
popish133812113popish
punish111411503punish
pupfish1735533pupfish
radish103516913radish
raffish1658843raffish
rakish134313963rakish
ratfish1338773ratfish
ravish123414033ravish
rawish123012913rawish
reddish1238033reddish
relist64628413rel_ist
sailfish1446053sailfish
saltish10312163saltish
sawfish1637683sawfish
selfing112911623selfing
selfishly1843633selfishly
selfs85220243self_s_
shellfish1843223shellfish
slash84719683sl_ash
slavish1338233slavish
sleigh10258203sleigh
slosh84514483sl_osh
slowish1337633slowish
slush85316573sl_ush
softish13127813softish
squish1838573squish
sunfish1338883sunfish
swellfish1842703swellfish
swish115114823_swish
tallish103313583tallish
tilefish1445453tilefish
tonish93415903tonish
toyish122911123toyish
unselfish1542673unselfish
unwish1239093unwish
uppish1336633uppish
vanish121513203vanish
waifish1637703waifish
weakfish2143523weakfish
weakish17217173weakish
wearish132310153wearish
welsh113110363wel__sh
wennish1336243wennish
wettish1335963wettish
whish144512923_whish
widish13419363widish
wildish1446853wildish
winish124212263winish
wish107228733__wish
wolffish2043333wolffish

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162676.00018786.0
3Display Results2672670.0932871.0
 (SQL Overall)1786912676.23328668.5
 
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.