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

351 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
cyphers1731675(None) 
ciphers14379981ciphers
cypher16306591cypher_
syphers15317271syphers
capers105428132cap_ers
cappers134419402cappers
cipher133710262cipher_
cithers124315752cithers
copers104629842cop_ers
copiers114215962copiers
coppers133519752coppers
copters113621272copters
coshers123618172coshers
cuppers133712192cuppers
cyclers1435872cyclers
cyders12398832cy_ders
cyphered1934652cyphered
cypres1338522cypre_s
cypress1434652cypress
gophers1338982gophers
gyppers15235502gyppers
hypers144811912hyp_ers
hyphens1836042hyphens
sypher14317082sypher_
aethers103614943aethers
anthers103715203anthers
apers76629133_ap_ers
archers124414573archers
aspers86220313asp_ers
bashers124820833bashers
bathers124720363bathers
boppers133911923boppers
bothers124317753bothers
bushers124018803bushers
cabers105023903c_abers
cablers114416713cablers
caches137926913cache_s
cachets145014263cachets
cadgers114711993cadgers
cagers95624183c_agers
cahiers123510673cahiers
calkers134414693calkers
callers94221963callers
calypters1643583calypters
cambers134017433cambers
campers134220283campers
camphors1737053camphors
cancers114018583cancers
caners84629193c_aners
cankers134418753cankers
canners93822663canners
canoers94318373canoers
canters94827723canters
caper94831623cap_er_
caperers122611723caperers
capes95441923cap_e_s
caphs124515373caph__s
capless114312763capless
caplets114914523caplets
capper124421983capper_
captors113914983captors
carders104820353carders
careers95218783careers
carers85133953c_arers
carpers114521253carpers
carters95327243carters
carvers124817533carvers
cashes114729883cashe_s
cashews15428603cashews
cashiers13318883cashiers
casters94729893casters
catchers153114053catchers
caters85336493c_aters
causers94014783causers
cavers115026833c_avers
ceders93817673c_eders
ceilers93912533ceilers
censers94313903censers
centers94420593centers
cepes94424463cep_e_s
cepheid1545433cepheid
cepheids1644243cepheids
chafers154512723chafers
chapters154012113chapters
chars105936633c__hars
chasers123714893chasers
chawers154412033chawers
cheders134512393cheders
cheers114518913c_heers
chefs136214663c__hefs
chert105232103c__hert
cherts115617233c__herts
chess105016923c__hess
chewers154111133chewers
chews135418513c__hews
chiders135312943chiders
chimers144515133chimers
chippers173510873chippers
chokers164311513chokers
cholers124215193cholers
choppers174110453choppers
ciders94620083c_iders
cinders104617753cinders
ciphered1637053ciphered
cipherer1545573cipherer
cipherers1644883cipherers
citers85022973c_iters
cither114616683cither_
cithern12489913cithern
citherns13338863citherns
clappers143310833clappers
clashers134213993clashers
clavers124314893clavers
clawers123910963clawers
clippers14368833clippers
clivers123411753clivers
cloners94514823cloners
closers94415313closers
clovers125114663clovers
clypeus1433243clyp_eus
clysters13227823clysters
coachers154312293coachers
coalers94419333coalers
coaters93525773coaters
coaxers164311063coaxers
cobbers134114753cobbers
cockers153618333cockers
codders114114443codders
coders95426973c_oders
codgers115113923codgers
coffers154112693coffers
coheirs1236753c_oheirs
cohere112716993c_ohere
coheres122917693c_oheres
coilers93619903coilers
coiners93620753coiners
colters93522433colters
combers134516613combers
comers105328083c_omers
compeers143410013compeers
confers124120093confers
congers104223233congers
conkers133721043conkers
conners94023113conners
cooers84324563c_ooers
cookers134619463cookers
coolers93522493coolers
coopers114019483coopers
cooters94525713cooters
copens106119963cop_ens
coper95336093cop_er_
copes97747103cop_e_s
copier103722893copier_
copies104130303copie_s
copper124321893copper_
copperas14308563copperas
coppery16409393coppery
copses104922473copse_s
copter109822013copter_
corders104520873corders
corers85231073c_orers
corkers134118853corkers
corners94723313corners
coryphees1953143coryphees
cosher114819903cosher_
coshes115022783coshe_s
costers94128303costers
cotters94323433cotters
couchers153513843couchers
coughers14399953coughers
couplers123311313couplers
couters93827283couters
covers114627963c_overs
cowers114625533c_owers
cowherb1735103cowherb
cowherbs1833543cowherbs
cowherd1636953cowherd
cowherds1735423cowherds
crappers144011023crappers
crashers134013223crashers
craters95021883craters
cravers124416543cravers
criers83918583c_riers
croppers143311483croppers
crowers124614893crowers
crozers184111083crozers
cruppers14317313cruppers
crushers134010083crushers
cubers105318343c_ubers
cullers93418843cullers
culvers12329823culvers
cumbers134515393cumbers
cummers133713473cummers
cunners93913463cunners
cupelers1266733cupelers
cupels10310203cup_els
cupper124313863cupper_
curbers115514373curbers
curers84923183c_urers
curlers94218063curlers
cursers94317153cursers
cussers94213393cussers
cutlers94216993cutlers
cutters94218953cutters
cyber124910383cy_ber_
cycler1335913cycler_
cyclery1763493cyclery
cycles1339303cycle_s
cyder114611133cy_der_
cyeses11510123cyese_s
cygnets1333813cygnets
cymars13599143cy_mars
cymes1210118923cy_me_s
cyphering20175243cyphering
cypreses1535143cypreses
cyprus1335363cyp_rus
cypsela1442443cypsela
dashers115016863dashers
deciphers1744383deciphers
dippers123615173dippers
dithers114016153dithers
dopers95522483dop_ers
dupers94615603dup_ers
dyers96617133dy__ers
enciphers1644013enciphers
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
pushers123814503pushers
rapers84327183rap_ers
raphes115117453raphe_s
rapiers95012873rapiers
rappers113618443rappers
rashers104020903rashers
rippers114115023rippers
ropers84325903rop_ers
rushers103816103rushers
sappers113518893sappers
scepters1237783scepters
scuppers1446533scuppers
scyphus1743203scyph_us
scythes15356523scythe_s
sighers113712173sighers
sippers113117743sippers
speers85019953_speers
sphere113313653_sphere
spheres123114353_spheres
sphery14318883_sphery
spiers84421743_spiers
supers84622403sup_ers
suppers113314693suppers
syphered1755013syphered
syphons1537503syphons
syphs13519453syph__s
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 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.1601116818.8
2DLD Change Limit1340273515.98322401.3
3Display Results3513510.1232853.7
 (SQL Overall)1786913516.26628517.6
 
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.