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

190 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
cymbal1523691(None) 
cymbals16236141cymbals
tymbal13236821tymbal
cabal95222152c_abal
cambial134010762cambial
cembali13156042cembali
cembalo13145532cembalo
comal95125132com_al
combat12316752combat
cyma116715842cym_a_
cymae126713012cym_ae
cymar125711262cym_ar
cymas126417882cym_as
cymbaler1743112cymbaler
cymbalom1942292cymbalom
cymol1287622cym_ol
gimbal11228812gimbal
hymnal1434912hymnal
jumbal1758462jumbal
sambal105215182sambal
symbol1336082symbol
timbal102510752timbal
tombal102311022tombal
tymbals14265722tymbals
atabal839743atabal
bal56662723___bal
barbal104016663barbal
bombax1935753bombax
bubal94218213_bubal
byssal1134993byssal
cabala103516913c_abala
cabals104020153c_abals
cabbala1367183cabbala
cabman123812503cabman
caecal103713733caecal
camail10314833camail
camas96333523cam_as
camber124418483camber
cambia124913153cambia
camel96822803cam_el
cameral11311283cameral
canal75428043c_anal
cantal84122033cantal
carnal83919203carnal
carpal103716253carpal
casbah1337903casbah
casual81112863casual
caudal91611483caudal
causal81413203causal
cayman133613213caym_an
cecal94619113c_ecal
ceiba938703ceiba_
ceibas1038503ceibas
cembalos14135163cembalos
cental84420963cental
cercal10314123cercal
cereal8315833cereal
chiral114614413chiral
chital114313883chital
choral115118493choral
cibol9512023c_ibol
cimbalom1642443cimbalom
citral81113893citral
clinal8311553clinal
clonal8310913clonal
clypeal1443513clypeal
coal66939253c__oal
coaxal15387303coaxal
cobalt10317393c_obalt
coccal9310223coccal
coeval1138893coeval
coital84117053coital
coma87134853com_a_
comae97128423com_ae
comas95833003com_as
comb106632113comb__
combats13311683combats
combe116223543comb_e
combed135516543combed
comber125118503comber
combes125321733combes
combo114519433comb_o
combos125316613combos
combs116122963comb_s
comical13312223comical
comma114514793comma_
commas124814573commas
compas125817063compas
compel124412893compel
copal95621783c_opal
coral76033453c_oral
corban10314693corban
corbel103715973corbel
corral83616253corral
costal85419513costal
coxal146116673c_oxal
craal74117753c_raal
credal9311673credal
crural8610633crural
cryptal1445683cryptal
crystal1237433crystal
cumber124016703cumber
cumbia12379893cumbia
cumbias13338963cumbias
cuneal8611513cuneal
curial84019153curial
curtal83914543curtal
cuspal1037883cuspal
cyan96419623cy__an
cyber124910383cy_ber
cycad13507273cy_cad
cycas126513823cy_cas
cymars13599153cymars
cymbaleer1841753cymbaleer
cymbalers1842843cymbalers
cymbalist1855483cymbalist
cymbaloms2052063cymbaloms
cyme119420373cym__e
cymene1377393cymene
cymes1210118923cym_es
cymlin1337313cymlin
cymoid1459473cymoid
cymols1377193cymols
cymose13429653cymose
cymous1388403cymous
cynical1437873cynical
domal85619203dom_al
embalm1236653_embalm
embar94011603_embar
embay123410603_embay
eyeball1245063eyeball
eyebar1135323eyebar
gamba106018513gamba_
gambas115817513gambas
gambol1138223gambol
gimbals12257823gimbals
gimmal11247513gimmal
global937663global
gumball1266833gumball
gyral94412783gy_ral
hamal104623113ham_al
hammal134512063hammal
hemal104419803hem_al
herbal112513493herbal
hyetal1236543hyetal
hymenal1545183hymenal
hymnals1543523hymnals
hyphal1736413hyphal
imbalm1246323_imbalm
jumbals18106533jumbals
limba95414983limba_
limbas105313203limbas
lumbar103610593lumbar
mamba116317523mamba_
mambas125716243mambas
mammal95112753mammal
meal65643173__meal
mimbar1297493mimbar
numbat10312083numbat
nymphal1744033nymphal
pibal95217323_pibal
ramal74622243ram_al
rambla103510933rambla
rumba93612513rumba_
rumbas102512013rumbas
sabal75422483_sabal
samba95618773samba_
sambals115213483sambals
sambar103914163sambar
sambas104219263sambas
scribal1137963scribal
scumbag1443573scumbag
symbols1435523symbols
tamal73522623tam_al
tambac122210243tambac
tambak14249263tambak
tambala1138023tambala
timbale11248803timbale
timbals11239533timbals
timbral11237193timbral
tombac12258883tombac
tombak14237753tombak
tribal8611133tribal
tubal75517203_tubal
tympan13257013tympan
typal105311153ty_pal
umbel93612843_umbel
umbral1038633_umbral
verbal112513663verbal
wombat1339863wombat

Search took 6 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 Limit1127161905.17321789.3
3Display Results1901900.0603166.7
 (SQL Overall)1786911905.37333257.2
 
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.