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

363 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
shekels143604(None) 
shekel1338381shekel_
sheqels1934751sheqels
heels85625532_he_els
seekers113712332seekers
seels55632822s_e_els
shakers144015562shakers
shakes135024592shake_s
sheals94420642she_als
sheens95116992she_ens
sheers94322402she_ers
sheets93918502she_ets
shekelim1742232shekelim
shells94319522she_lls
sheols94614162she_ols
sheqel1846522sheqel_
shewers134312052shewers
shiels95418922sh_iels
shovels13378392shovels
shtetels1143232shtetels
speels85116392spe_els
steels64117982ste_els
wheels123811712whe_els
bedels94015273_bedels
betels84515063_betels
bevels113913983_bevels
bezels173712283_bezels
chapels14429153chapels
chebecs1635013chebecs
checkers19317843checkers
cheders134512393cheders
cheeks154712783che_eks
cheeps135312913che_eps
cheers114518913che_ers
chewers154111143chewers
chiels115115933ch_iels
chisels12219103chisels
chokers164311523chokers
chokes154917383choke_s
creels84416943cre_els
crenels93711013crenels
crewels12438493crewels
deckels14367363deckels
dekes105224453_deke_s
devels104313903_devels
diesels8429143diesels
dishevels1653633dishevels
djebels1753293djebels
eels46536743__e_els
ekes86726603__eke_s
feels85223043_fe_els
ghees95215553ghe_e_s
hakes126034303_hake_s
hazels185710083_hazels
heals85733453_he_als
hebes105521673_hebe_s
heckles163711383_heckles
heders104119763_heders
heeds95420423_he_eds
heel75034223_he_el_
heils85222193_he_ils
hells85032043_he_lls
hemes105031083_heme_s
heres86245903_here_s
herls85226433_he_rls
hewers123715273_hewers
hexers165612753_hexers
hexes155123043_hexe_s
hexyls1933433_hexyls
hikers135014353_hikers
hikes125426983_hike_s
hokes126231643_hoke_s
hosels94218603_hosels
hotels94515513_hotels
hovels125413333_hovels
jebels15418913_jebels
jewels16508613_jewels
keels94622413_ke_els
kevels134410713_kevels
kneels10408933kne_els
levels94113283_levels
newels93710823_newels
nickels13338653nickels
peels75226423_pe_els
pekes114623563_peke_s
phenols1238103phenols
phenyls1534333phenyls
rebels84518133_rebels
reekers113613143reekers
reels55333263_re_els
refels94618053_refels
reheels10298253reheels
rekeys13347693_rekeys
repels84318763_repels
revels94220573_revels
rhemes115913183rheme_s
sackers133820223sackers
sakers104125433s_akers
sakes95540753s_ake_s
samiels939763samiels
saurels749303saurels
scenes84520353scene_s
schemers1576713schemers
schemes1489663scheme_s
seals54839693s_e_als
seders74420283s_eders
seeders83017113seeders
seeds64330063s_e_eds
seeker103615363seeke_r
seeks94724643s_e_eks
seel45042983s_e_el_
seely84522633s_e_ely
seemers93814333seemers
seems75525023s_e_ems
seeps74828753s_e_eps
seeress7311573seeress
seers55136383s_e_ers
sees45361053s_e_e_s
seidels838393seidels
selles64426983s_elles
sells55134433s_e_lls
sels46345983s___els
semens84616963s_emens
semes75731583s_eme_s
sepals85217373s_epals
sequels1665703sequels
seres55448893s_ere_s
sevens93813663s_evens
severs94121123s_evers
sewers94719723s_ewers
sexes126126223s_exe_s
shackles173010593shackles
shaders115915553shaders
shades105924533shade_s
shake124726403shake__
shaken134113613shake_n
shaker134319463shake_r
shakeup1632763shakeup
shakeups1742373shakeups
shakily1736903shakily
shakoes144510023shakoes
shakos134912193shak_os
shales94731253shale_s
shames114726223shame_s
shapely1536893shapely
shapers124016893shapers
shapes115124943shape_s
sharers104720623sharers
shares95236413share_s
sharkers154011053sharkers
shauls94913113sh_auls
shavers134115093shavers
shaves125224933shave_s
shawls125411973sh_awls
sheafs124912883she_afs
sheal84927703she_al_
shearers113911323shearers
shears93820903she_ars
sheas86331793sh__eas
sheaths1358753sheaths
sheaves134412973sheaves
shebean1235763shebean
shebeans1344703shebeans
shebeen1234553shebeen
shebeens1343333shebeens
shedders13267433shedders
sheds96122703sh__eds
sheen85023313she_e_n
sheeneys14294903sheeneys
sheeny124912193she_eny
sheep105321523she_e_p
sheer84726893she_e_r
sheerly13337703sheerly
sheesh1237813she_esh
sheet84836963she_e_t
sheeters113111863sheeters
sheeve123412843she_eve
sheeves133911953sheeves
shegetz2044273shegetz
sheikhs17233993sheikhs
sheiks132510013she_iks
sheila969843she_ila
sheilas1059403sheilas
shekalim1742533shekalim
shelf115221113sh__elf
shell84424123sh__ell
shelled113815083shelled
sheller103515883sheller
shellers112812573shellers
shelly124414473she_lly
sheltas10279673sheltas
shelters113412813shelters
shelvers14388813shelvers
shelves134112093shelves
shends105313773she_nds
sheol84318373she_ol_
sherbets1335213sherbets
sherds105614723she_rds
shereef1337743shereef
shereefs1433863shereefs
sherifs13299683sherifs
sherpas1238093sherpas
sherris10168803sherris
shes75734353sh__e_s
sheuchs15234933sheuchs
sheughs14264533sheughs
shewed134716183shewe_d
shewer124515113shewe_r
shews115924713sh__ews
shickers173012823shickers
shiel811023773sh_iel_
shield106212973sh_ield
shields11538043sh_ields
shiers94921753sh_iers
shies86136553sh_ie_s
shikars1436183shikars
shikkers14326523shikkers
shiksas1484643shiksas
shiksehs1892093shiksehs
shikses14116573shikses
shills94519613sh_ills
shiners104015943shiners
shines95028913shine_s
shires95225573shire_s
shirkers15319583shirkers
shivers133714833shivers
shives124921413shive_s
shlemiels14102503shlemiels
shleps114710333sh_leps
shmoes114612103shmoe_s
shoals94215793sh_oals
shockers17319463shockers
shoeless1137803shoeless
shoers94518333sh_oers
shoes85429663sh_oe_s
shools94919013sh_ools
shores94830413shore_s
shorls94516203sh_orls
shotes95321913shote_s
shovel124611323shovel_
shovers134613003shovers
shoves124919423shove_s
showers134612683showers
shreds105613053sh_reds
shrews129313923sh_rews
shriekers16224423shriekers
shrieks14377673shrieks
shrikes144412393shrike_s
shrills10389933shrills
shrivels14376443shrivels
shtetel1033943shtetel_
shtetls1034583shtetls
shuckers17388133shuckers
shuls85319713sh__uls
shutes93518223shute_s
shyers124712203sh_yers
shyness1344993shyness
sickees134514213sickees
sickens134411483sickens
sickles133417543sickles
sieges73816833siege_s
siemens938413siemens
sieves93216003sieve_s
sikes96236083s_ike_s
simnels976103simnels
sinkers113618543sinkers
skeens103912913ske_ens
skees95023123s__kees
skeets104513253ske_ets
skegs105011233s__kegs
skell94915833s__kell
skells105013783ske_lls
skelm114211293s__kelm
skelms12368023s__kelms
skelp114211423s__kelp
skelps12407923s__kelps
skenes104616633skene_s
skeps115614253s__keps
skewers14498383skewers
skews125413803s__kews
slakers114115753slakers
slakes104021883slake_s
sleekens12274873sleekens
sleekers12377993sleekers
sleekly14325193sleekly
sleeks104512463sle_eks
sleeps83913323sle_eps
sleets64318873sle_ets
smeeks12428433sme_eks
smells83914743sme_lls
smokers13389323smokers
smokes124814343smoke_s
snakes103919603snake_s
sneakers12308643sneakers
sneers64016173sne_ers
snells64614203sne_lls
snivels10336903snivels
snorkels1234413snorkels
soakers114114953soakers
sockets134012983sockets
sokes95031423s_oke_s
sokols10399093s_okols
sorels63921163s_orels
sorrels7310723sorrels
speakers14299453speakers
speckles16268133speckles
speeds94316053spe_eds
speel74420763spe_el_
speers85019953spe_ers
speils84116223spe_ils
spells84617683spe_lls
spewers124210663spewers
sphenes123013163sphene_s
spheres123114353sphere_s
spiegels1133873spiegels
spiels85317953s_piels
spikers135311993spikers
spikes124520713spike_s
spinels94512443spinels
spokes124417213spoke_s
stakes103927293stake_s
steals64020063ste_als
steeds73814883ste_eds
steeks103613703ste_eks
steel55721993ste_el_
steely93612573ste_ely
steeps85215193ste_eps
steers63820983ste_ers
steles63725663stele_s
stereos74314973stereos
steres63929533stere_s
sterols7313443sterols
stipels9418953stipels
stokers114515183stokers
stokes104821793stoke_s
streels73811343streels
suckers133717623suckers
suckles134516743suckles
suedes73918113suede_s
sulkers113613343sulkers
sunkets113511283sunkets
swedes102711893swede_s
sweeps114110513swe_eps
sweets94214433swe_ets
swells93913983swe_lls
swevens1334613swevens
swivels13396773swivels
sykes124816863s_yke_s
teels55726373_te_els
thebes115914493thebe_s
themes115319253theme_s
theres96525473there_s
thermels13607763thermels
theses96517973these_s
vakeels14113733vakeels
wedels103811033_wedels
wheals124512523whe_als
wheel115515333whe_el_
wheens124610613whe_ens
wheeps14439953whe_eps
whereas13448903whereas
wheres125917433where_s
yokels13488063_yokels

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.406440125.6
2DLD Change Limit1340273636.18621666.2
3Display Results3633630.1262881.0
 (SQL Overall)1786913636.71826598.8
 
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.