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 “cymbalt” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 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
cymbal15236911cymbal_
cymbals16236141cymbals
cembali13156042cembali
cembalo13145532cembalo
cobalt10317392c_obalt
combat12316752comba_t
cymbaler1743112cymbaler
cymbalist1855482cymbalist
cymbalom1942292cymbalom
tymbal13236822tymbal_
tymbals14265722tymbals
bombast1348223bombast
cabal95222153c_abal_
cabala103516913c_abala
cabals104020153c_abals
cabbala1367183cabbala
cambial134010763cambial_
cambist13312113cambist
cembalist1547633cembalist
cembalos14135163cembalos
cimbalom1642443cimbalom
cobalts1139203c_obalts
comal95125133com_al_
combats13311683combats
combust1338353combust
compact153712213compact
compart134016003compart
cyma116715843cym_a__
cymae126713013cym_a_e
cymar125711263cym_a_r
cymars13599153cym_ars
cymas126417883cym_a_s
cymbaleer1841753cymbaleer
cymbalers1842843cymbalers
cymbalists1944073cymbalists
cymbaloms2052063cymbaloms
cymol1287623cym_ol_
cymols1377193cym_ols
embalm1236653_embalm
eyeball1245063eyeball
eyebolt1246363eyebolt
gimbal11228813gimbal_
gimbals12257823gimbals
gumball1266833gumball
gymnast1344153gymnast
hymnal1434913hymnal_
hymnals1543523hymnals
imbalm1246323_imbalm
jumbal1758463jumbal_
jumbals18106533jumbals
lambast11129893lambast
malt66254803__m_alt
numbat10312083numba_t
sambal105215183sambal_
sambals115213483sambals
smalt74729333_sm_alt
symbiot1465273symbiot
symbol1336083symbol_
symbols1435523symbols
tambala1138023tambala
timbal102510753timbal_
timbale11248803timbale
timbals11239533timbals
tombal102311023tombal_
wombat1339863womba_t

Search took 9 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 Limit134027657.93616888.5
3Display Results65650.0461413.0
 (SQL Overall)178691658.13821957.6
 
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.