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

306 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
chebec153696(None) 
chebecs1635011chebecs
cheder125113492cheder
cheek145115712che_ek
cheep125416502che_ep
cheer105420382che_er
chefed155010562chefed
chemic153012092chemic
chewed154415012chewed
chewer145512612chewer
hebe96424702_hebe_
hebes105521672_hebes
rebec94416542_rebec
thebe107515432thebe_
thebes115914492thebes
xebec16378292_xebec
zebec18419262_zebec
achene11313813achene_
achenes12313493achenes
amebic1239103amebic
beebee10313063beebee
cabbed135416263cabbed
caber95126833c_aber
camber124418473camber
cebid104314063c_ebid
cede74928763c_ede_
ceded96118553c_eded
ceder85322233c_eder
cedes84927323c_edes
cee55952703c_e_e_
cees65941593c_e_es
celeb9314873c_eleb
cepe84926653c_epe_
cepes94424463c_epes
cere66741473c_ere_
cered85227443c_ered
ceres75540013c_eres
ceric94023093c_eric
cete64934783c_ete_
cetes75731103c_etes
chabuk1734673chabuk
chaebol1444943chaebol
chafe135117353chafe_
chafed154813913chafed
chafer144714573chafer
chafes145017913chafes
chaleh143711993chaleh
chalet113825993chalet
chamber164011053chamber
chance134617093chance
chape125221143chape_
chapel134911373chapel
chapes135421873chapes
chare105231983chare_
chared125423693chared
chares115631803chares
chase105127123chase_
chased125019293chased
chaser114918383chaser
chases115128233chases
chawed155214603chawed
chawer144314413chawer
cheap126915943che_ap
cheapen14407623cheapen
cheaper144010583cheaper
cheapo134810083cheapo
cheaps134613683cheaps
cheat105732453che_at
cheated134416343cheated
cheater124816953cheater
cheats114519543cheats
check164714713che_ck
checked193710023checked
checker18329533checker
checks174912703checks
cheders134512393cheders
cheeked17399663cheeked
cheeks154712783cheeks
cheeky18448613cheeky
cheeped153410593cheeped
cheeper143610743cheeper
cheeps135312913cheeps
cheered133713293cheered
cheerer123511753cheerer
cheero114712933cheero
cheers114518913cheers
cheery144913153cheery
cheese113812763cheese
cheesed133910683cheesed
cheeses123613103cheeses
cheesy14419193cheesy
chef125125623ch__ef
cheffed19335863cheffed
chefs136214663che_fs
chegoe1237273chegoe
chegoes1337333chegoes
chela103916803che_la
chelae113614603chelae
chelas113817203chelas
chemics16349573chemics
chemo12313633che_mo
chemos13311723chemos
cheque2036663cheque
chequer2135153chequer
cheques2136863cheques
cherry144810763cherry
chert105232103che_rt
cherts115617233cherts
cherty144612473cherty
cherub1337263cherub
cherubic1743303cherubic
chess105016923che_ss
chesses124112633chesses
chest104926143che_st
chested133811673chested
chests114916263chests
chesty144610503chesty
chetah14399583chetah
cheth135013823che_th
cheths14389823cheths
chevied16357483chevied
chevies153511443chevies
chevre14318313chevre
chevres15379793chevres
chevret153310633chevret
chevy16479993che_vy
chew126622133ch__ew
chewers154111133chewers
chewier1537583chewier
chews135418513che_ws
chewy165011903che_wy
chez184519023ch__ez
chic115925203ch__ic
chicer134513603chicer
chide115321013chide_
chided135113963chided
chider125116053chider
chides124620473chides
chief134419473ch_ief
chiefer1536863chiefer
chiel104918973ch_iel
chile105626893chile_
chiles115425303chiles
chime125322593chime_
chimed145814833chimed
chimer135517203chimer
chimes134922573chimes
chine105231723chine_
chined125620063chined
chines115029173chines
chisel112111943chisel
chive135117623chive_
chives144317593chives
choice132010523choice
choke145118023choke_
choked164914793choked
choker154314373choker
chokes154917383chokes
chokey184811713chokey
choler113717153choler
chore105126763chore_
chorea115216083chorea
chored125321883chored
choreic1438693choreic
chores114828023chores
choric133515893choric
chose105925403chose_
chosen116014133chosen
choses115825123choses
chowed154914643chowed
chub115516413chub__
chubby1844123chubby
chubs125412623chub_s
chute104316463chute_
chuted124611843chuted
chutes114615763chutes
chyle134913483chyle_
chyles144813283chyles
chyme156512503chyme_
chymes165912153chymes
chymic18317883chymic
cleek115514913cle_ek
clepe94617383clepe_
cleped115114113cleped
clepes104214623clepes
cleric10612133cleric
clever114611533clever
clewed1225113203clewed
cobber124116843cobber
codec107120343c_odec
coerce10310403coerce
coerect11913353coerect
cohere112716993cohere_
cohered133514693cohered
coherer122912783coherer
coheres122917693coheres
combe116223543combe_
combed135516543combed
comber125118503comber
combes125321733combes
corbel103715973corbel
cosec96320183c_osec
creed85727393cre_ed
creek114917393cre_ek
creel75121483cre_el
creep95218103cre_ep
creme94319323creme_
cremes104517993cremes
crenel84213063crenel
crepe95520723crepe_
creped114115703creped
crepes105419343crepes
crepey135110933crepey
cretic102816283cretic
crewed125316553crewed
crewel114310473crewel
cube85830213c_ube_
cubeb115814653c_ubeb
cubed105519703c_ubed
cuber95222533c_uber
cubes95028163c_ubes
cubic114313413c_ubic
cumber124016703cumber
curbed114615873curbed
curber104517053curber
cusec94614903c_usec
cyber124910383c_yber
cyeses11510123cyeses
djebel1643453djebel
ephebe1336063ephebe_
ephebes1436153ephebes
ephebic1646513ephebic
exec135313943__exec
ghee85726113ghe_e_
ghees95215553ghe_es
glebe85016443glebe_
glebes95512243glebes
grebe85114943grebe_
grebes93813613grebes
hebetic1438633_hebetic
heder95623633_heder
heed86437603_he_ed
heel75034223_he_el
heme95034413_heme_
hemes105031083_hemes
hemic125718623_hemic
hence104920043_hence
herbed123513453_herbed
here76447103_here_
heres86245903_heres
hewed125619433_hewed
hewer115719933_hewer
hexed165615763_hexed
hexer155116683_hexer
hexes155123043_hexes
jebel145612143_jebel
leben7314853_leben
ochered132610283ochered
phobic153010063phobic
phoebe1335003phoebe_
phoebes1435813phoebes
plebe95014873plebe_
plebes104313623plebes
rebeck14419913_rebeck
rebecs103913673_rebecs
rebel73421293_rebel
rhebok1534613rhebok
rheme106214053rheme_
rhemes115913183rhemes
scheme1379633scheme_
schemed1577753schemed
schemer1477953schemer
schemes1489663schemes
shebean1235763shebean
shebeen1234553shebeen
sheen85023313she_en
sheep105321523she_ep
sheer84726893she_er
sheet84836953she_et
shekel1338383shekel
sheqel1846523sheqel
sherbet12311383sherbet
shewed134716183shewed
shewer124515103shewer
thee78039063the_e_
theme105921733theme_
themed125912583themed
themes115319253themes
thence112010843thence
there87527393there_
theres96525473theres
these86519013these_
theses96517973theses
thetic11412883thetic
weber10313523_weber
whee105429593whe_e_
wheel115515333whe_el
wheen115016053whe_en
wheep136214353whe_ep
whence14187923whence
where117019423where_
wheres125917433wheres
wheyey1834323wheyey
xebecs17355363_xebecs
zebeck23255203_zebeck
zebecs19316183_zebecs

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163066.29617902.8
3Display Results3063060.1102781.8
 (SQL Overall)1786913066.54627297.7
 
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.