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

215 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
serfish134897(None) 
selfish1388511selfish
deafish1438532deafish
dervish1436982dervish
elfish1267962_elfish
garfish14179202garfish
jewfish2343542jewfish
nerdish1137102nerdish
oarfish13158612oarfish
overfish1737892overfish
perish114619062per_ish
perkish16258822perkish
redfish1437792redfish
sawfish1637682sawfish
serais64326132serais_
serfs84922012serf_s_
serifs94017052serifs_
spearfish1743602spearfish
starfish1438082starfish
sunfish1338882sunfish
surffish1744782surffish
batfish1558683batfish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
boarfish1635753boarfish
boxfish2285543boxfish
burnish1238623burnish
carlish12312773carlish
catfish1559023catfish
ceorlish1345383ceorlish
cercis104614493cercis_
ceriph1398463cer_iph
cerise84822043cer_ise
cherish15310463cher_ish
clerkish1744263clerkish
codfish1637163codfish
cowfish1836433cowfish
currish1238353currish
darkish1537943darkish
dealfish1545503dealfish
defis96717503de_fis_
delish105215613de_lish
dermis94717163dermis_
derris73615273derris_
dogfish15226763dogfish
dryish1336323_dryish
dwarfish1843783dwarfish
elvish1277563_elvish
fermis114313503fermis_
fetish12310373fe_tish
finfish16268193finfish
fish106926283___fish
foxfish2354483foxfish
furbish1536443furbish
furnish1337383furnish
garish104516933gar_ish
garnish111610853garnish
girlish1137193girlish
greyish1435173greyish
hagfish17227613hagfish
headfish1845443headfish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
heroism12311013heroism
hogfish17257023hogfish
huffish1935713huffish
kerfing15307533kerfing
kerfs125413573kerf_s_
kermis124012403kermis_
largish1138603largish
larkish1439083larkish
leftish13197253leftish
marish114319063mar_ish
mudfish1646263mudfish
nebbish1444253nebbish
nereis6315343nereis_
newish1237903ne_wish
oafish121311733_oafish
offish15137273_offish
ogreish1134673ogreish
ogrish1039263ogr_ish
outfish132210573outfish
panfish15229983panfish
parish115022363par_ish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
perfidy1635273perfidy
perfuse1247663perfuse
peris75537073per_is_
persist9315853persist
pettish1238283pettish
pigfish16217173pigfish
pinfish15319303pinfish
pupfish1735533pupfish
raffish1658843raffish
ratfish1338773ratfish
reddish1238033reddish
refresh1335453refresh
relish93916953re_lish
reraise7316313reraise
rerise64325633rer_ise
rosefish1445263rose_fish
sailfish1446053sailfish
saltish10312163saltish
sandfish1556683sandfish
saris54544953sar_is_
scraich1436763scraich
scraigh1335673scraigh
seifs85019333seif_s_
seis45542393se__is_
seise54727853se__ise
seism75019023se__ism
selfing112911623selfing
selfishly1843633selfishly
selfs85220243self_s_
semis74623533se_mis_
sepsis83011293sepsis_
seracs84418573seracs_
serai56830163serai__
serail64222673serai_l
serails73318363serails
seraph114011163ser_aph
seraphs12408093seraphs
serein63318463serei_n
sereins73716123sereins
seres55448893ser_es_
serest64831613ser_est
serf76340113serf___
serfage1138403serfage
serfdom1344213serfdom
serflike1536273serflike
serges74225973serges_
serging93416673serging
serial64625863ser_ial
series64540973ser_ies
serif84132133ser_i_f
serifed11811463serifed
serin55434443ser_i_n
serine65432673ser_ine
sering74731813ser_ing
serins64029673ser_ins
serosa6313023ser_osa
serous65023563serous_
serows96016393serows_
serpigo1044833serpigo
serried82513973serried
serries73925353serries
sers45746653ser__s_
serums83916303serums_
serves94423653serves_
service1239093service
servile10310643servile
serving113014983serving
servos93812723servos_
sexism15227653se_xism
sexist133013483se_xist
sheatfish1843253sheatfish
sheepish1645413sheepish
shellfish1843223shellfish
sherifs13299683sherifs_
sherris10168803sherris_
shortish1437423shortish
shrewish1744743shrewish
shris84221453shr_is_
sickish1638423sickish
silverfish1952173silverfish
skirmish1743263skirmish
skreigh15243703skreigh
slavish1338233slavish
slowish1337633slowish
sniffish1744513sniffish
softish13127813softish
sottish10129443sottish
sourish10310693sourish
sparkish17276973sparkish
squish1838573s_quish
sris45434153s_r_is_
steepish1375823steepish
stiffish1745243stiffish
stonish10410653stonish
studfish1544523studfish
stylish13197443stylish
suckfish2043893suckfish
surfier102613543surfier
surfiest112414433surfiest
surfing112914483surfing
surfs85022543surf_s_
surmise9311083surmise
sweetish1445373sweetish
swellfish1842703swellfish
swinish1347203swinish
swish115114823s__wish
swordfish1942223swordfish
tarnish101611883tarnish
tartish101512633tartish
terais64023513terais_
unselfish1542673unselfish
varnish13169553varnish
verism113214263ver_ism
verist93823893ver_ist
vermis114214963vermis_
viperfish2042943viperfish
waifish1637703waifish
warmish1538373warmish
weakfish2143523weakfish
weakish17217173weakish
wearish132310153wearish
wennish1336243wennish
wettish1335963wettish
wolfish1636933wolfish
wormish1537163wormish
zebrafish2651783zebrafish

Search took 10 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.813219792.1
2DLD Change Limit1340272158.73315347.2
3Display Results2152150.0762828.9
 (SQL Overall)1786912159.62218571.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.