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

412 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
syphers1531727(None) 
cyphers17316751cyphers
sypher14317081sypher_
ciphers14379982ciphers
cypher16306592cypher_
gophers1338982gophers
gyppers15235502gyppers
hypers144811912hyp_ers
hyphens1836042hyphens
sappers113518892sappers
sighers113712172sighers
sippers113117742sippers
speers85019952s_peers
sphere113313652s_phere
spheres123114352s_pheres
sphery14318882s_phery
spiers84421742s_piers
supers84622402sup_ers
suppers113314692suppers
syphered1755012syphered
syphons1537502syphons
syphs13519452syph__s
aethers103614943aethers
anthers103715203anthers
apers76629133_ap_ers
archers124414573archers
aspers86220313asp_ers
bashers124820833bashers
bathers124720363bathers
boppers133911923boppers
bothers124317753bothers
bushers124018803bushers
capers105428133cap_ers
cappers134419403cappers
cipher133710263cipher_
cithers124315753cithers
copers104629843cop_ers
copiers114215963copiers
coppers133519753coppers
copters113621273copters
coshers123618173coshers
cuppers133712193cuppers
cyclers1435873cyclers
cyders12398833cy_ders
cyphered1934653cyphered
cypres1338523cypre_s
cypress1434653cypress
dashers115016863dashers
dippers123615173dippers
dithers114016153dithers
dopers95522483dop_ers
dupers94615603dup_ers
dyers96617133dy__ers
ephors11311403_ephors
etchers123411293etchers
ethers94518413_ethers
eyers86521333ey__ers
fathers133916503fathers
fishers134714723fishers
gapers94520463gap_ers
gathers114315063gathers
gippers123212073gippers
gopher1239183gopher_
gushers113512503gushers
gypper14347293gypper_
gypsters1434023gypsters
hers75844873___hers
hopers114222973hop_ers
hoppers143115143hoppers
hyper135213903hyp_er_
hypes135818673hyp_e_s
hyphen1736393hyphe_n
imphees1436693imphees
inchers123912523inchers
japers154616173jap_ers
joshers174111593joshers
kashers143914023kashers
kippers153211423kippers
koshers144811803koshers
kythes16499133kythe_s
lappers113717463lappers
lapsers93911053lapsers
lashers104121833lashers
lathers104321883lathers
lechers123313963lechers
lepers84817323lep_ers
lippers113416433lippers
lopers84424143lop_ers
loppers113014103loppers
lychees15516783lychees
lyches144213613lyche_s
lynchers16285453lynchers
mappers133313773mappers
mashers124621053mashers
mithers123516733mithers
mopers104220373mop_ers
moppers133412453moppers
moshers124017843moshers
mothers123717623mothers
mushers124016433mushers
mynheers1642113mynheers
nappers114214863nappers
nephews1533323nephews
nippers113012613nippers
noshers103614323noshers
nymphets1862703nymphets
ochers113915303_ochers
others93918003_others
ouphes113614633ouphe_s
oyers87620883oy__ers
oysters103411683oysters
papers105125323pap_ers
peers75130273__peers
peppers103311443peppers
piers75926333__piers
pipers104318663pip_ers
pishers123815753pishers
poppers103414863poppers
pothers123818623pothers
psyches1755803psyche_s
pushers123814503pushers
rapers84327183rap_ers
raphes115117453raphe_s
rapiers95012873rapiers
rappers113618443rappers
rashers104020903rashers
rippers114115023rippers
ropers84325903rop_ers
rushers103816103rushers
sabers85224733s_abers
sachems14348903sachems
sachets123914103sachets
sackers133820223sackers
sadhes104715373sadhe_s
saggers94017083saggers
sailers73822313sailers
sakers104125433s_akers
salters73622253salters
salvers103916003salvers
samplers12299403samplers
sanders84025943sanders
sangers84421943sangers
saphead1357773saphead
sapheads1466083sapheads
saphena1235863saphena
saphenas1345713saphenas
sapiens9310173sapiens
sapless93313443sapless
sapors84118813sap_ors
sapours93610613sapours
sapper103822353sapper_
sashes94728483sashe_s
saucers93712133saucers
saugers83914053saugers
savers93825923s_avers
sawers94620163s_awers
sawyers13317533sawyers
sayers94221593s_ayers
scalers93817263scalers
scarers94618503scarers
scepters1237783scepters
scorers94115313scorers
scoters93313793scoters
scuppers1446533scuppers
scyphus1743203scyph_us
scythes15356523scythe_s
sealers74323553sealers
seamers94719433seamers
seaters74028933seaters
seders74420283s_eders
seeders83017113seeders
seekers113712333seekers
seemers93814333seemers
seers55136383s__eers
seiners74219273seiners
seisers73816393seisers
seizers164112503seizers
sellers73721303sellers
senders83022353senders
senhors103512123senhors
sepses84515883sepse_s
septets998953septets
sergers83815633sergers
sers45746653s___ers
servers103214833servers
setters73822063setters
severs94121123s_evers
sewers94719713s_ewers
shaders115915553shaders
shakers144015563shakers
shapers124016893shapers
sharers104720623sharers
shavers134115093shavers
shears93820903s__hears
sheas86331793s__heas
sheds96122703s__heds
sheers94322403s_heers
shepherd1744373shepherd
shepherds1843223shepherds
sherd96321153s__herd
sherds105614723s__herds
shes75734353s__he_s
shewers134312043shewers
shews115924713s__hews
shiers94921753s_hiers
shiners104015943shiners
shippers153012303shippers
shivers133714833shivers
shoers94518323s_hoers
shophars1646353shophars
shoppers153010753shoppers
shovers134612993shovers
showers134612663showers
shushers14267053shushers
shyers124712203s_hyers
shysters14106433shysters
sidlers83414223sidlers
sifters103714783sifters
sigher103813703sigher_
sighters122510593sighters
signers84714423signers
sillers73822093sillers
silvers104714033silvers
simmers113314613simmers
simpers113014113simpers
singers83824693singers
sinkers113618543sinkers
sinners74019013sinners
sinters74024073sinters
sipes76036953sip_e_s
siphons1239343siphons
sipper103920983sipper_
sippets113310173sippets
sisters73721573sisters
sithens1039383sithens
sitters74221543sitters
sivers95324153s_ivers
sizers155215813s_izers
skaters113512943skaters
skewers14498373skewers
skiers104713693s_kiers
skippers16318193skippers
skivers14409693skivers
skyphos1963733skyph_os
slakers114115753slakers
slappers123710933slappers
slashers113313603slashers
slaters73123723slaters
slathers113914773slathers
slavers103716503slavers
slayers104513323slayers
slicers94114923slicers
sliders83515223sliders
slippers123711223slippers
slithers114212953slithers
slivers104115253slivers
slopers94213093slopers
slypes114410483slyp_e_s
smashers13339583smashers
smilers94113843smilers
smiters93414363smiters
smithers13369793smithers
smokers13389323smokers
smothers13349933smothers
snappers123510163snappers
snarers74216663snarers
sneers64016173s_neers
snipers93311763snipers
snippers12299713snippers
snorers74313793snorers
soakers114114953soakers
soapers93715923soapers
soarers74118093soarers
sobbers114114253sobbers
sobers85218853s_obers
soccers1138393soccers
solders83517773solders
solvers104414253solvers
sonders83820713sonders
sooners73916643sooners
soothers113913433soothers
sophies12314603sophies
sophs104916023soph__s
sopors85215193sop_ors
sorners73416863sorners
sorters74221113sorters
souters74422583souters
southers114214453southers
sowers94923433s_owers
spacers113813873spacers
spaders104214473spaders
spaes76029973s_pae_s
spahees1238263spahees
sparers94519613sparers
spares84834553s_pares
spars75431543s_p_ars
spears84019473s_pears
specs96916673s_p_ecs
speeds94316053s_peeds
speels85116393s_peels
speer74623903s_peer_
speirs85013233s_peirs
sperm93216013s_p_erm
sperms102512603s_p_erms
spewers124210653spewers
spews105015923s_p_ews
sphene113412403s_phene
sphenes123013163s_phenes
spheral1238423s_pheral
sphered133512313s_phered
spheric14510073s_pheric
spherics1537073s_pherics
spicers113815553spicers
spiders103914413spiders
spiels85317953s_piels
spier75728033s_pier_
spies76037623s_pie_s
spikers135311993spikers
spires84628113s_pires
spoors84014023s_poors
spores84726613s_pores
sprees85620643s_prees
spues75025383s_pue_s
spurs74621523s_p_urs
stagers84116673stagers
staplers103111183staplers
starers74522313starers
staters73922323staters
stayers103813633stayers
steers63820983s_teers
steppers12289273steppers
stivers103613533stivers
stokers114515183stokers
stoners74817953stoners
stopers94217363stopers
stoppers123910573stoppers
storers75018683storers
stovers103713733stovers
stylers10359343stylers
subers85722643s_ubers
suckers133717623suckers
sudsers83310413sudsers
suers55128483s__uers
suffers133113543suffers
suiters73618873suiters
sulkers113613343sulkers
sulphurs1383653sulphurs
summers113616503summers
sumpters1238023sumpters
sunders84120053sunders
super74924483sup_er_
superb104410993sup_erb
supes75628303sup_e_s
supper104115433supper_
surfers103614133surfers
surgers83517483surgers
sutlers73116973sutlers
swagers114211023swagers
swappers15358073swappers
swashers14389523swashers
swathers144512073swathers
swayers13398853swayers
swishers14328053swishers
swithers144310533swithers
syboes1139343syboe_s
sycees11409653sy_cees
syces106416463sy_ce_s
sykes124816863sy_ke_s
sylphids1743953sylphids
sylphs1435543sylph__s
syndets1136113syndets
syph125413273syph___
syphering18175733syphering
syphilis1645823syphilis
syphon1436853syph_on
syrens94911993sy_rens
syrphids1744243syrphids
systems1234673systems
tapers84025813tap_ers
tappers113416543tappers
telphers1335473telphers
tethers103815313tethers
tippers113414343tippers
tithers104216733tithers
tochers123413093tochers
topers85025323top_ers
tophes115218423tophe_s
toppers113914603toppers
tyers86220053ty__ers
types105721063typ_e_s
typhons1537083typhons
typhous1566323typhous
typhus14395713typh_us
typier1137333typier_
tythes12419703tythe_s
uppers102912283_uppers
ushers94415533_ushers
vipers114914533vip_ers
washers134517523washers
wethers135214693wethers
wipers115416083wip_ers
wishers133215213wishers
withers134417753withers
wuthers133711523wuthers
wyches17387913wyche_s
xysters17307163xysters
yagers105114533_yagers
yappers144012253yappers
zappers203911633zappers
zephyrs2441943zephyrs
zippers203310373zippers
zithers193911973zithers

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.1531167915.0
2DLD Change Limit1340274127.98616782.7
3Display Results4124120.1562641.0
 (SQL Overall)1786914128.29521542.0
 
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.