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

392 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
sachems1434890(None) 
sachem134012221sachem_
sachets123914101sachets
aches106132292_ache_s
baches135426942bache_s
caches137926912cache_s
cachets145014262cachets
laches116528342lache_s
maches134827232mache_s
maihems1444302maihems
mayhems1763412mayhems
naches114622412nache_s
rachets124516832rachets
sachemic1746082sachemic
sachet114725772sache_t
sackers133820222sackers
sacrums11388042sacrums
sadhes104715372sadhe_s
sashes94728482sashe_s
satchels13328162satchels
schema1388372s_chema
schemas1468162s_chemas
scheme1379632s_cheme
schemes1489662s_chemes
taches114224172tache_s
access1037673_access
aces67645093_ac_e_s
ache96829823_ache__
ached119227833_ache_d
achene11313813_achene
achenes12313493_achenes
ackees124914573_ackees
acmes96020653_acme_s
acnes75922623_acne_s
acres76327763_acre_s
adeems946333_adeems
ahem97225363_a_hem_
alchemy1743113alchemy
anthems12309423anthems
apaches143411833apache_s
archers124414573archers
arches114822043arche_s
ashes86230613_ashe_s
bached145519893bache_d
backers153821883backers
bashers124820833bashers
bashes115631393bashe_s
batchers153613273batchers
batches144019613batche_s
bathers124720363bathers
bathes116524833bathe_s
beaches144120653beache_s
boches134618523boche_s
braches144621223brache_s
brachets154311983brachets
cache125122483cache__
cached145419203cache_d
cachet134526413cache_t
cachexy2443283cachexy
cachous14312583cachous
cashes114729883cashe_s
cashews15428603cashews
catchers153114063catchers
catches144320773catche_s
chams126028503__chams
chefs136214663__chefs
chemo12313633__chemo
chemos13311723__chemos
chess105016923__chess
chews135418513__chews
chums125015833__chums
coachers154312303coachers
coaches144018693coache_s
daces85030683dac_e_s
dachas124113253dach_as
dackers143417043dackers
dashers115016863dashers
dashes106124983dashe_s
drachms1534253drach_ms
duchess1335553duchess
eches106322163_eche_s
eschews1534553eschews
etchers123411293etchers
etches114217763etche_s
facers115519443fac_ers
faces106439433fac_e_s
facets116316653fac_ets
facies113921593facie_s
fashes124524023fashe_s
fathers133916503fathers
fathoms1537523fathoms
fiches145219533fiche_s
gashes105725153gashe_s
gathers114315073gathers
haceks15447863hac_eks
hackees165014103hackees
hackers164619043hackers
haems105517013ha__ems
hakeems16394803hakeems
hareems12428203hareems
harems115513823ha_rems
hashes125024803hashe_s
hatchels16368673hatchels
hatchers163113173hatchers
hatches153420273hatche_s
hatchets163310383hatchets
hems95534943___hems
inchers123912523inchers
inches114419673inche_s
isocheims1663143isocheims
itches114916213itche_s
jackers204214453jackers
jackets205011373jackets
kashers143914023kashers
kuchens1634713kuchens
lacers85225253lac_ers
laces76141763lac_e_s
lackers134120543lackers
lackeys16458263lackeys
lactams1136953lactams
larches124416443larche_s
lashers104121833lashers
lashes94831003lashe_s
latches123320123latche_s
latchets133410013latchets
lathers104321883lathers
lathes95127493lathe_s
leachers133712813leachers
leaches123319343leache_s
lechers123313963lechers
leches115421313leche_s
lichees123512783lichees
lichens123510683lichens
liches114724293liche_s
loaches123613983loache_s
lychees15516783lychees
lyches144213613lyche_s
macers105321273mac_ers
maces97139963mac_e_s
mache125925303mache__
machete14310883machete
machetes1539633machetes
machos135217493mach_os
machrees1545503machrees
machs125722563mach__s
macles107023223macle_s
maihem1366213maihem_
manches143818623manche_s
manchets15269573manchets
marchers153710813marchers
marches143921173marche_s
mashers124621053mashers
mashes115030003mashe_s
matchers153012433matchers
matches143219783matche_s
mayhem1644923mayhem_
miches134320733miche_s
muches134718993muche_s
nachas114914193nach_as
nachos115014183nach_os
nacres85614453nacre_s
niches114419143niche_s
ochers113915303_ochers
oraches124216473orache_s
ouches114322183ouche_s
pacers105124543pac_ers
paces96741113pac_e_s
pachas135017143pach_as
packers153818893packers
packets155114773packets
parches143720003parche_s
pashes115828393pashe_s
patchers153413303patchers
patches143320383patche_s
peachers153213843peachers
peaches144120053peache_s
poachers152910763poachers
poaches144416943poache_s
psyches1755803psyche_s
raceme1039733rac_eme
racemes1139093rac_emes
racers84725433rac_ers
races74943243rac_e_s
rachet115028973rache_t
rachis114017653rach_is
racisms112310813racisms
rackers134320453rackers
rackets134916873rackets
ranchers133311793ranchers
ranches123620113ranche_s
raphes115117453raphe_s
rashers104020913rashers
rashes95330153rashe_s
ratches123620463ratche_s
ratchets133110263ratchets
reachers133515723reachers
reaches123423203reache_s
rechews1537293rechews
rehems113410983_rehems
richens12349733richens
riches115022083riche_s
roaches123616213roache_s
rochets124213473rochets
ruches114819583ruche_s
sabers85224733sa_bers
sabes76437463sa_be_s
sables85026693sable_s
sabres85520863sabre_s
sacbuts1166473sacbuts
sacheted14127833sacheted
sacked135525213sacke_d
sacker125124843sacke_r
sacks114228873sac__ks
sacques18106863sacques
sacrals93311793sacrals
sacred94917103sacre_d
sacrum103910143sacrum_
sacs65739073sac___s
saddens9309603saddens
sades65239893sa_de_s
sadhe94815133sadhe__
sadhus10298463sadh_us
sadisms10359113sadisms
sadness8310613sadness
safes85226723sa_fe_s
sages65339063sa_ge_s
saggers94017083saggers
sahibs1137083sa_hibs
saices84221803saice_s
sailers73822323sailers
sakers104125433sa_kers
sakes95540753sa_ke_s
salaams997703salaams
salchows1644203salchows
saleps85014903sa_leps
sales56055593sa_le_s
sallets73719653sallets
salters73622253salters
salvers103916003salvers
salves94221763salve_s
sameks12409323sa_meks
samiels939763samiels
samlets93813553samlets
sanctums1244013sanctums
sanders84025943sanders
sanes55649073sa_ne_s
sangers84421943sangers
sanies63031953sanie_s
sanseis73011603sanseis
santims9312593santims
saphead1357773saphead
sapheads1466083sapheads
saphena1235863saphena
saphenas1345713saphenas
sapiens9310173sapiens
sapless93313443sapless
sappers113518903sappers
sarcasms1244983sarcasms
sarees65329943sa_rees
sarges75128593sarge_s
sarsens7311393sarsens
sashays1336333sashays
sashed105622943sashe_d
sashimi1244643sashimi
sashimis1343753sashimis
sashless1136603sashless
sasses64124393sasse_s
satchel123310303satche_l
sateens73710753sateens
satem76021453sa_tem_
sates54949323sa_te_s
saucers93712133saucers
sauces84919503sauce_s
sauchs115112233sauch__s
sauciers1076733sauciers
saugers83914053saugers
saurels749293saurels
sautes63924913saute_s
savers93825923sa_vers
saves85838633sa_ve_s
sawers94620163sa_wers
sawneys13274643sawneys
sawyers13317533sawyers
saxes125229343sa_xe_s
sayeds10469253sa_yeds
sayers94221593sa_yers
scalers93817263scalers
scales84529313scale_s
scams94423973s_c_ams
scapes105122263scape_s
scarers94618503scarers
scares85033003scare_s
scathes124515713scathe_s
schavs1436493s_chavs
schemed1577753s_chemed
schemer1477953s_chemer
schemers1576703s_chemers
schism1338173s_chism
schisms1437173s_chisms
schleps1445483s_chleps
schmo124510203s_ch_mo
schmos13379153s_chmos
schuls11299853s_chuls
schuss11186733s_chuss
schwas14396983s_chwas
scrams105216623s_crams
screams114810613s_creams
screes85023963s_crees
screws115513883s_crews
scrims104615933s_crims
scrums104614253s_crums
scums95017423s_c_ums
searchers14197353searchers
searches132112903searche_s
secrets9311773secrets
seems75525023s__eems
seiches12513813seiche_s
shams105829413s__hams
sheas86331793s__heas
sheds96122703s__heds
shes75734353s__he_s
shews115924713s__hews
shims104422543s__hims
sices75637273sic_e_s
sickees134514213sickees
sickens134411483sickens
sighers113712183sighers
sithens1039383sithens
slackens14367713slackens
slackers143812743slackers
slashers113313613slashers
slashes103619103slashe_s
slatches131511523slatche_s
slathers113914783slathers
smackers16318713smackers
smashers13339593smashers
smashes123914613smashe_s
snackers143010223snackers
snashes105214753snashe_s
snatchers14146313snatchers
snatches131410713snatche_s
snathes104816493snathe_s
soccers1138393soccers
sockets134012983sockets
socles8418453socle_s
spacers113813873spac_ers
spaces104722633spac_e_s
spahees1238263spahees
spathes125116533spathe_s
spirems11499563spirems
stackers143413563stackers
stactes91914633stacte_s
stanchers14206813stanchers
stanches132312793stanche_s
starches131912913starche_s
stashes103916173stashe_s
stems75219953s__tems
success1146403success
suchness1335763suchness
suckers133717623suckers
sucres84218893sucre_s
swashers14389533swashers
swashes134714403swashe_s
swatches16169963swatche_s
swathers144512083swathers
swathes134115513swathe_s
sycees11409653syc_ees
syces106416463syc_e_s
syphers15317273syphers
systems1234683systems
taces76237803tac_e_s
tache106222373tache__
tachism1478873tachism
tachisms1567143tachisms
tachs105820933tach__s
tackers134319623tackers
tackets134914363tackets
tandems1037633tandems
teachers133212393teachers
teaches122718353teache_s
tochers123413093tochers
tracheas13410273tracheas
vacuums1443403vacuums
wackes154717713wacke_s
washers134517523washers
washes124425493washe_s
watchers163511793watchers
watches153017373watche_s
wiches144418753wiche_s
wyches17387913wyche_s
yachters1633883yachters
yachts1437023yach_ts

Search took 8 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.1561145455.1
2DLD Change Limit1340273927.04619021.7
3Display Results3923920.1402800.0
 (SQL Overall)1786913927.34224338.2
 
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.