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

144 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
cymbals1623614(None) 
cymbal15236911cymbal_
tymbals14265721tymbals
cabals104020152c_abals
cembali13156042cembali
cembalo13145532cembalo
cembalos14135162cembalos
combats13311682combats
cymars13599152cym_ars
cymas126417882cym_a_s
cymbaler1743112cymbaler
cymbalers1842842cymbalers
cymbalist1855482cymbalist
cymbalom1942292cymbalom
cymbaloms2052062cymbaloms
cymols1377192cym_ols
gimbals12257822gimbals
hymnals1543522hymnals
jumbals18106532jumbals
sambals115213482sambals
symbols1435522symbols
timbals11239532timbals
tymbal13236822tymbal_
atabals938413atabals
bals66354043___bals
bubals103513843_bubals
cabal95222153c_abal_
cabala103516913c_abala
cabalas113516003c_abalas
cabbala1367183cabbala
cabbalas1467373cabbalas
camails11311753camails
camas96333523cam_a_s
camass104114183cam_ass
cambers134017443cambers
cambial134010763cambial_
camels105217083cam_els
canals84421663c_anals
cantals93919573cantals
carpals113414623carpals
casbahs1436463casbahs
casuals91410523casuals
causals91411183causals
caymans14349513caym_ans
ceibas1038503ceiba_s
cembalist1547633cembalist
centals94317053centals
cereals9313173cereals
chorals124614113chorals
cibols1039523c_ibols
cimbalom1642443cimbalom
cimbaloms1741973cimbaloms
citrals91111673citrals
coals76129603c__oals
cobalt10317393c_obalt
cobalts1139203c_obalts
coevals1237873coevals
comal95125133com_al_
comas95833003com_a_s
combat12316753comba_t
combers134516623combers
combes125321733comb_es
combos125316613comb_os
combs116122963comb__s
commas124814573comma_s
compas125817063compa_s
compass13379563compass
compels133210883compels
copals105018943c_opals
corals85325143c_orals
corbans11313173corbans
corbels113813593corbels
corrals93713853corrals
craals84113303c_raals
crystals1347173crystals
cumbers134515413cumbers
cumbias13338963cumbias
curtals93111623curtals
cyans105714813cy__ans
cycads14476213cy_cads
cycas126513823cy_ca_s
cyma116715843cym_a__
cymae126713013cym_a_e
cymar125711263cym_a_r
cymbaleer1841753cymbaleer
cymbaleers1951413cymbaleers
cymbalists1944073cymbalists
cymenes1477413cymenes
cymes1210118923cym__es
cymlins1436693cymlins
cymol1287623cym_ol_
cymous1388403cym_ous
embalm1236653_embalm
embalms1335333_embalms
embars103812883_embars
embays131408333_embays
eyeball1245063eyeball
eyeballs1344213eyeballs
eyebars1245333eyebars
gambas115817513gamba_s
gambols1238593gambols
gimbal11228813gimbal_
gimmals12225823gimmals
gumball1266833gumball
gumballs1345313gumballs
hamals114816823ham_als
hammals14409223hammals
herbals122710603herbals
hymnal1434913hymnal_
imbalm1246323_imbalm
imbalms1334553_imbalms
jumbal1758463jumbal_
limbas105313203limba_s
lumbars11289763lumbars
mambas125716243mamba_s
mammals10389273mammals
meals75933373__meals
mimbars1397383mimbars
numbats1137673numbats
pibals103813083_pibals
ramblas112710263ramblas
rumbas102512013rumba_s
sabals84618863_sabals
sambal105215183sambal_
sambars115113843sambars
sambas104219263samba_s
scumbags1543203scumbags
symbol1336083symbol_
tamals84116633tam_als
tambacs13219363tambacs
tambaks15218153tambaks
tambala1138023tambala
tambalas1237033tambalas
timbal102510753timbal_
timbale11248803timbale
timbales12227843timbales
tombacs13248443tombacs
tombaks15246863tombaks
tombal102311023tombal_
tribals9610753tribals
tympans14236813tympans
umbels104510593_umbels
verbals121910743verbals
wombats1435893wombats

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.390458182.1
2DLD Change Limit1340271446.39020974.5
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.82626178.0
 
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.