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

235 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
seraphs1240809(None) 
serapes95218101serapes
seraph114011161seraph_
ceriphs1484752ceriphs
gerahs1039412gera_hs
graphs124510152_graphs
paraphs1439312paraphs
sarapes94617752sarapes
scarphs14437412scarphs
scrapes116217662scrapes
scraps106017242scrap_s
selahs9313212sela_hs
seracs84418572sera_cs
serails73318362serails
serais64326132sera_is
serape84818412serap_e
seraphic1546632seraphic
seraphim1544802seraphim
seraphims1644042seraphims
seraphin1345952seraphin
staphs114411032s_taphs
straps87721782strap_s
straths102711722straths
surahs94515542sura_hs
teraph11319092teraph_
aerates74627493aerates
agrapha1345133agrapha
becaps123811403becap_s
bedrapes1386963bedrapes
berakes134815773berakes
berates94126873berates
berths114712423ber_ths
bewraps14135403bewrap_s
brachs134415753_brachs
breaths124411183breaths
caphs124515373__caphs
cerates95428253cerates
ceriph1398463ceriph_
crapes104727693_crapes
craps95328643_crap_s
curaghs1334583curaghs
dearths11498843dearths
deaths105914443de_aths
derails84216393derails
derates84028893derates
derats74625063dera_ts
derays105514253dera_ys
digraphs15105753digraphs
drapes95419653_drapes
earths95014593_earths
eras45441503_era__s
erases64425403_erases
erupts8348903_erupts
escapes113811673escapes
etapes85415293_etapes
ferals94216643fera_ls
fraps105620553_frap_s
gerah9315303gera_h_
grapes95123123_grapes
graph115315613_graph_
heaps105223223he_ap_s
hearths135311073hearths
heaths126316383he_aths
heralds1137713heralds
herpes115517323her_pes
horahs126313873hora_hs
isographs1546723isographs
kaphs144911503__kaphs
khaphs18394323_khaphs
leaps75522933le_ap_s
morphs13149433mor_phs
neaps75618323ne_ap_s
paraph13311263paraph_
perhaps1446123perhap_s
periapts1237273periapts
perps95521483per_p_s
ralphs1135373__ralphs
rapes75740723__rapes
raphe104916423__raphe
raphes115117453__raphes
raphis114014323__raphis
raps66247733__rap_s
reaps75626193re_ap_s
recaps103615733recap_s
remaps105012873remap_s
reracks132310533reracks
retapes93917423retapes
rewraps12136563rewrap_s
saps65346373s__ap_s
sarans64224433sara_ns
sarape84817573sarap_e
satraps95011643satrap_s
scapes105122263s_capes
scarph13429603scarph_
scarps104718603scarp_s
scrags95713803scra_gs
scraichs1543993scraichs
scraighs1443633scraighs
scrams105216623scra_ms
scrap97120403scrap__
scrape105917573scrap_e
scraped124313133scraped
scraper114513423scraper
scrapers125510533scrapers
scrapie115010943scrapie
scrapies124612483scrapies
scrappy16234473scrappy
scrawls12177283scrawls
scrips105316033scrip_s
scripts11509373scripts
seals54839693se_a_ls
seams75731663se_a_ms
search113312423search_
searches132112903searches
sears54744913se_a_rs
seas45755273se_a__s
seats54844343se_a_ts
secants93413893secants
secpars1138413secpars
sedans74816093seda_ns
sedates83418043sedates
seeps74828753se_ep_s
selah8319613sela_h_
senates73322613senates
sepals85217373sepa_ls
septs75420603se__pts
sera46141393sera___
serac75925203sera__c
serai56830163sera__i
serail64222673sera_il
seral56336383sera__l
serdabs1035323serdabs
sereins73716123sereins
serenes73222903serenes
seres55448893ser__es
serfages1238233serfages
serfish1348973serfish
serfs84922013ser__fs
sergers83815633sergers
serges74225973ser_ges
serials73919743serials
seriates82620673seriates
series64540973ser_ies
serifs94017053ser_ifs
serigraphs1645433serigraphs
serines74229543serines
serins64029673ser_ins
serious73616283serious
sermons9311783sermons
serosas7312663serosas
serous65023563ser_ous
serows96016393ser_ows
serranos857873serranos
serrates82617023serrates
serries73925353serries
sers45746653ser___s
serums83916303ser_ums
servals103410743servals
servants1138003servants
servers103214833servers
serves94423653ser_ves
servos93812723ser_vos
sesames9310743sesames
setups83910463setup_s
sewages1139753sewages
sewans95215903sewa_ns
sewars94018633sewa_rs
shahs115919513s_ha_hs
shapes115124953s_hapes
sharps115516083sharp_s
sheaths1358753sheaths
sherpas1238093sher_pas
shnapps1463343shnapps
shnaps1148083shnap_s
sirrahs10377303sirrahs
sirups83710533sirup_s
slaps76025713s_lap_s
snaps74719563s_nap_s
snaths95112913s_naths
sneaps84510863sneap_s
soaps75120713s_oap_s
sophs104916023s__ophs
soras55041013sora__s
sprags95715823spra_gs
sprains93013593sprains
sprangs104610053sprangs
sprats85819933spra_ts
sprawls12176373sprawls
sprays115913643spra_ys
sradha1085333s_radha
sradhas1176153s_radhas
stapes85028733s_tapes
staph104314653s_taph_
strafes104516003strafes
strains74218153strains
straits74916323straits
strakes114218073strakes
strands83711953strands
strap77925263strap__
strappy14205263strappy
strass67117223stra_ss
stratas73013583stratas
strath93216373strath_
stratus73011733stratus
straws98718673stra_ws
strays96417933stra_ys
streps86218063strep_s
stripes95320573stripes
strips85719653strip_s
strophe1239143strophe
strophes13310603strophes
strops86220383strop_s
subahs114512383suba_hs
subgraphs1743733subgraphs
sumachs14457353sumachs
surah86823253sura_h_
suras55336333sura__s
surpass938283surpass
swaps104819203s_wap_s
swarths13537323swarths
swaths125312643s_waths
sylphs1435543s_ylphs
syphs13519453s__yphs
syrups11277953syrup_s
terais64023513tera_is
teraohm1244783teraohm
teraohms1343703teraohms
teraphim1545003teraphim
torahs95115643tora_hs
trapes85024463_trapes
traps75727483_trap_s
wraps105617153_wrap_s
wraths123810083_wraths
wreaths13338373wreaths
yeahs115214553ye_a_hs

Search took 9 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.436409841.7
2DLD Change Limit1340272357.68617437.8
3Display Results2352350.0802937.5
 (SQL Overall)1786912358.20221786.3
 
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.