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

54 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
cymbaler174311(None) 
cymbaleer1841751cymbaleer
cymbalers1842841cymbalers
combater1439382combater
cymbal15236912cymbal__
cymbaleers1951412cymbaleers
cymbalom1942292cymbalom
cymbals16236142cymbal_s
ambler104916453_amb_ler
baler75635273___baler
bumbler134013233bumb_ler
cabler104519173c_ab_ler
camber124418483camb__er
capabler1435353capabler
cembali13156043cembal_i
cembalo13145533cembal_o
cembalos14135163cembalos
cimbalom1642443cimbalom
coaler84121713c__oaler
cobbler133311823c_obbler
comaker153410603com_aker
combated1539823combated
combaters1538113combaters
comber125118503comb__er
combiner14259723combiner
comparer143611363comparer
compiler1438373compiler
cumber124016703cumb__er
cumberer14266993cumberer
cyber124910383cy_b__er
cycler1335913cy__cler
cymae126713013cym_a_e_
cymar125711263cym_a__r
cymbalist1855483cymbalist
cymbaloms2052063cymbaloms
embalmer1444063_embalmer
empaler11288353_empaler
fumbler143610813fumb_ler
gambler123612683gamb_ler
gimbaled14104173gimbaled
humbler143411943humb_ler
imbalmer1443193_imbalmer
impaler11298393_impaler
jumbler183910273jumb_ler
mumbler133510913mumb_ler
nimbler11358063nimb_ler
rambler113313263ramb_ler
rumbler113514113rumb_ler
symboled1644493symboled
timbale11248803timbale_
timbales12227843timbales
tumbler113412823tumb_ler
tymbal13236823tymbal__
tymbals14265723tymbal_s

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 Filter1786911461620.436409841.7
2DLD Change Limit146162547.61019206.6
3Display Results54540.0163375.0
 (SQL Overall)178691548.06222164.6
 
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.