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

82 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
sabbath144539(None) 
sabbat10314711sabbat_
sabbaths1543971sabbaths
sabbats1138631sabbats
sabbatic1445322sabbatic
sunbath1236422sunbath
abash106016513_a_bash
abate76627843_a_bate
abba810522653_abba__
abbacy1536623_abbacy
abbas95918643_abba_s
abbot9318453_abbot_
abbots1039283_abbots
ablate82219213_ablate
abwatt11410673_abwatt
albata839333_albata
babbitt1038033babbitt
barbate11314543barbate
bath95940083___bath
cabbage1446983cabbage
cabbagy1744013cabbagy
cabbala1367183cabbala
cabbalah1763793cabbalah
casbah1337903casba_h
gabbard1336553gabbard
gabbart1248883gabbart
gabbarts1344063gabbarts
isobath1244613isobath
jubbah2034353jubba_h
kabbala1584613kabbala
kabbalah1962433kabbalah
kasbah1535183kasba_h
labiate91313573labiate
rabat72832223ra_bat_
rabato83413263ra_bato
rabats83116223ra_bats
rabbet103818653rabbet_
rabbets11279423rabbets
rabbit102914563rabbit_
rabbits11299863rabbits
rabbity14266303rabbity
sabal75422483sa_ba_l
sabals84618863sa_bals
sabaton937713sa_baton
sabbatics1543393sabbatics
sabbed114518083sabb_ed
sabbing123314743sabbing
sabot7931783sa_bot_
sabots8314703sa_bots
sabra75317853sabra__
sabras85116363sabra_s
sacbut10811943sacbut_
sacbuts1166473sacbuts
saccate111311763saccate
sagbut959753sagbut_
sagbuts1065223sagbuts
saith85826553sa__ith
samba95618773samba__
sambaed1238303sambaed
sambal105215183samba_l
sambals115213483sambals
sambar103914163samba_r
sambars115113843sambars
sambas104219263samba_s
satiate7315403satiate
savate9313783sa_vate
scabbard1544203scabbard
seabeach1543663seabeach
shabbatot1652513shabbatot
sheath12412893s_heath
shibah14387473shiba_h
snath86419803s__nath
sorbate9311733sorbate
strath93216373s_trath
subah106015213s_uba_h
subbase1139323subbase
subbass1138033subbass
sublate9315363sublate
sunbathe1344033sunbathe
sunbaths1344383sunbaths
swath115920383s__wath
warpath1545203warpath

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.406440125.6
2DLD Change Limit134027825.89022755.0
3Display Results82820.0165125.0
 (SQL Overall)178691826.31228309.7
 
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.