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

90 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
cabbala1367181cabbala
cabal95222152ca_bal_
cabala103516912ca_bala
cabals104020152ca_bals
cabbage1446982cabbage
cabbagy1744012cabbagy
cabbalah1763792cabbalah
cabbalas1467372cabbalas
kabbala1584612kabbala
abba810522653_abba__
abbacy1536623_abbacy
abbas95918643_abba_s
babble94017113babb_le
baobab946403baoba_b
barbal104016663barbal_
cabalas113516003ca_balas
cabana103913563ca_bana
cabbaged1644383cabbaged
cabbages1537203cabbages
cabbagey1843213cabbagey
cabbalahs1862723cabbalahs
cabbalism1745683cabbalism
cabbalist1547643cabbalist
cabbed135416263cabb_ed
cabbie122913353cabb_ie
cabbies133115163cabbies
cabbing143613153cabbing
cabby145314563cabb__y
cable95329913ca_b_le
cabman123812503cabma_n
cabob114616813ca_b_ob
caecal103713733caecal_
cambial134010763cambial_
canal75428043ca_nal_
canals84421663ca_nals
cantal84122033cantal_
cantala94114673cantala
cantals93919573cantals
capable13313363capable
capably1639253capably
carbarn1139453carbarn
carnal83919203carnal_
carpal103716253carpal_
carpale113414353carpale
carpals113414623carpals
casbah1337903casba_h
casbahs1436463casbahs
casual81112863casual_
casuals91410523casuals
catalo8314853ca_talo
catcall1139153catcall
catfall1237393catfall
cattalo938423cattalo
catwalk1645323catwalk
caudal91611483caudal_
causal81413203causal_
causals91411183causals
cembali13156043cembali
cembalo13145533cembalo
cobalt10317393c_obalt
cobble123615263cobb_le
crabbily1744343crabbily
cymbal15236913cymbal_
cymbals16236143cymbals
dabble114515193dabb_le
falbala1235873falbala
gabbard1336553gabbard
gabbart1248883gabbart
gabble113815723gabb_le
kabab134814443ka_ba_b
kabala124011553ka_bala
kabbalah1962433kabbalah
kabbalas1674353kabbalas
labial84714343labial_
labials9299873labials
qabala17399193qa_bala
rabble103818243rabb_le
sabal75422483sa_bal_
sabals84618863sa_bals
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
sambal105215183sambal_
sambals115213483sambals
scabbard1544203scabbard
scabbily1763943scabbily
scabble13168653scabb_le
tambala1138023tambala
wabble133714843wabb_le
wabbly16348363wabb_ly

Search took 8 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.1531167915.0
2DLD Change Limit134027907.16018718.9
3Display Results90900.0303000.0
 (SQL Overall)178691907.34324334.9
 
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.