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

187 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
selfish138851(None) 
elfish1267961_elfish
serfish1348971serfish
deafish1438532deafish
dealfish1545502dealfish
delish105215612del_ish
elvish1277562_elvish
hellish13310722hellish
jewfish2343542jewfish
redfish1437792redfish
relish93916952rel_ish
sailfish1446052sailfish
saltish10312162saltish
sawfish1637682sawfish
selfing112911622selfing
selfishly1843632selfishly
selfs85220242self_s_
shellfish1843222shellfish
sunfish1338882sunfish
swellfish1842702swellfish
unselfish1542672unselfish
wolfish1636932wolfish
angelfish1642863angelfish
baldish1339503baldish
batfish1558683batfish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
billfish1645033billfish
blemish1436603blemish
bluish1159243_bluish
boxfish2285543boxfish
bullish12511193bullish
catfish1559023catfish
cellist9314423cellist
coalfish1635493coalfish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
cowfish1836433cowfish
cultish12139113cultish
damselfish1961163damselfish
defis96717503de_fis_
delfs94918673delf_s_
delfts10439673delfts_
delis64928543del_is_
delist74625053del_ist
dervish1436983dervish
devilfish1942323devilfish
dogfish15226763dogfish
dollish11610093dollish
doltish11118733doltish
dullish1148743dullish
elfin84312463_elfi_n
elfins94810943_elfins
elfishly1743503_elfishly
fallfish1744463fallfish
fetish12310373fe_tish
filefish1745593filefish
finfish16268193finfish
fish106926273___fish
flemish1536373flemish
fluish1239333_fluish
folkish1736563folkish
foolfish1744393foolfish
foxfish2354483foxfish
garfish14179203garfish
goldfish1644203goldfish
hagfish17227613hagfish
headfish1845443headfish
heimish1535463heimish
hennish1336863hennish
hogfish17257023hogfish
huffish1935713huffish
jellyfish2551903jellyfish
jewelfish2551703jewelfish
leftish13197253leftish
milkfish2043333milkfish
mudfish1646263mudfish
mulish11311903mul_ish
nebbish1444253nebbish
nerdish1137103nerdish
newish1237903ne_wish
oafish121311723_oafish
oarfish13158613oarfish
offish15137273_offish
oldish10169313_oldish
outfish132210573outfish
overfish1737893overfish
owlish1238703owl_ish
palish114718273pal_ish
panfish15229973panfish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
pelfs105016293pelf_s_
pelvis113610323pelvis_
perish114619063pe_rish
perkish16258823perkish
pettish1238283pettish
pigfish16217173pigfish
pinfish15319303pinfish
plenish1239943plenish
polish114916723pol_ish
pupfish1735533pupfish
raffish1658843raffish
ratfish1338773ratfish
reddish1238033reddish
relist64628413rel_ist
rosefish1445263rose_fish
sablefish1742903sablefish
salmis8514273salmis_
sandfish1556683sandfish
seifs85019333seif_s_
seis45542393se__is_
seise54727853se__ise
seism75019023se__ism
selah8319613sel__ah
selahs9313213selahs_
self75138293self___
selfdom1343733selfdom
selfed10310913self_ed
selfless1135013selfless
selfness1135153selfness
selkie102811693selki_e
selkies113513353selkies
selles64426983selles_
selling83225833selling
sells55134433sel_ls_
sels46345983sel__s_
selvas93812913selvas_
selves94119613selves_
semis74623533se_mis_
sepsis83011293sepsis_
serais64326133serais_
serfs84922013serf_s_
serifs94017053serifs_
sexism15227653se_xism
sexist133013483se_xist
sheatfish1843253sheatfish
sheepish1645413sheepish
sickish1638423sickish
slash84719683s_l_ash
slavish1338233slavish
sleigh10258203s_leigh
slosh84514483s_l_osh
slowish1337633slowish
slush85316573s_l_ush
smallish1346573smallish
sniffish1744513sniffish
softish13127813softish
soloist7915893soloist
sottish10129443sottish
sourish10310693sourish
spearfish1743603spearfish
splash1168823spl_ash
splosh1186543spl_osh
squish1838573s_quish
starfish1438083starfish
steepish1375823steepish
stiffish1745243stiffish
stonish10410653stonish
studfish1544523studfish
stylish13197443stylish
suckfish2043893suckfish
sulfas9311563sulfas_
sulfid1039063sulfi_d
sulfide1138103sulfide
sulfids1137293sulfids
sulfite10310473sulfite
surffish1744783surffish
sweetish1445373sweetish
swinish1347203swinish
swish115114823s__wish
sylis84316023syl_is_
sylphish1944273sylphish
tallish103313583tallish
tilefish1445453tilefish
waifish1637703waifish
weakfish2143523weakfish
weakish17217173weakish
wearish132310153wearish
welsh113110363wel__sh
wennish1336243wennish
wettish1335963wettish
wildish1446853wildish
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 Filter1786911340270.406440125.6
2DLD Change Limit1340271876.15621771.8
3Display Results1871870.0762460.5
 (SQL Overall)1786911876.63826919.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.