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

253 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
sabbats113863(None) 
sabbat10314711sabbat_
sabbath1445391sabbath
sabbaths1543971sabbaths
abbas95918642_abba_s
abbots1039282_abbots
gabbarts1344062gabbarts
rabats83116222ra_bats
rabbets11279422rabbets
rabbits11299862rabbits
sabals84618862sa_bals
sabbatic1445322sabbatic
sabbatics1543392sabbatics
sabots8314702sa_bots
sabras85116362sabra_s
sacbuts1166472sacbuts
sagbuts1065222sagbuts
sambals115213482sambals
sambars115113842sambars
sambas104219262samba_s
subbass1138032subbass
abas68642083_a_ba_s
abate76627843_a_bate
abates85825033_a_bates
abatis84317933_a_batis
abba810522653_abba__
abbacy1536623_abbacy
abbes96723523_abb_es
abbess10509773_abbess
abbeys13538423_abbeys
abbot9318453_abbot_
abets75621673_a_bets
ablate82219213_ablate
ablates92416903_ablates
ablauts936083_ablauts
aborts84916183_aborts
abuts75417073_a_buts
abwatt11410673_abwatt
abwatts1233403_abwatts
albas75925393_alba_s
albata839333_albata
albatas938373_albatas
ambits103713413_ambits
arhats9312973_arhats
babas96325733ba_ba_s
babbitt1038033babbitt
babbitts1144023babbitts
babbles104416323babbles
babkas146010143babka_s
baobabs1044443baobabs
barbate11314543barbate
barbets114915843barbets
barbuts11439843barbuts
bats66962333___bats
beats76042243__beats
blats75132503__blats
boats75635153__boats
bobcats1335993bobcats
brats75336013__brats
bubbas94110703bubba_s
cabals104020153ca_bals
cabbage1446983cabbage
cabbages1537203cabbages
cabbagy1744013cabbagy
cabbala1367183cabbala
cabbalas1467373cabbalas
cabbies133115163cabbies
cablets114216343cablets
carats85929023ca_rats
casbahs1436463casbahs
catboats1247873catboats
caveats1239803caveats
combats13311683combats
dabbers123813213dabbers
dabbles124514773dabbles
darbars10510093darbars
drabbets13294823drabbets
ebbets10376833_ebbets
fabbest1438033fabbest
gabbard1336553gabbard
gabbards1445753gabbards
gabbart1248883gabbart
gabbers124612833gabbers
gabbles124415413gabbles
gabbros12124653gabbros
gambas115817513gamba_s
gambits12399723gambits
gasbags1135473gasbags
gibbets12417723gibbets
gobbets12327643gobbets
habitats1346733habitats
habits113014653ha_bits
hagbuts1354933hagbuts
hazmats2136603hazmats
hobbits14317553hobbits
jabbers183610583jabbers
jabots1538883ja_bots
jubbahs2143623jubbahs
kababs14409773ka_babs
kabars124513953ka_bars
kabbala1584613kabbala
kabbalas1674353kabbalas
kanbans1337723kanbans
karats106420493ka_rats
kasbahs1634363kasbahs
labials9299873labials
labiate91313573labiate
labiates101011513labiates
labrets939363labrets
lambast11129893lambast
lambasts12145623lambasts
lariats7615053lariats
mambas125716243mamba_s
manats84623463ma_nats
nabbers113710463nabbers
numbats1137673numbats
qanats154112813qa_nats
rabat72832223ra_bat_
rabato83413263ra_bato
rabatos93010903ra_batos
rabbet103818653rabbet_
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613163rabb_is
rabbit102914563rabbit_
rabbity14266303rabbity
rabbles113517973rabbles
ragbags1135113ragbags
ratbags1035763ratbags
sabal75422483sa_ba_l
sabaton937713sa_baton
sabatons1037843sa_batons
sabbed114518083sabb_ed
sabbing123314743sabbing
sabers85224733sa_bers
sabes76437463sa_b_es
sabines94318483sabines
sabins85521983sa_bins
sabirs85414633sa_birs
sables85026693sa_bles
sabot7931783sa_bot_
sabra75317853sabra__
sabres85520863sa_bres
sabs66643743sa_b__s
sacbut10811943sacbut_
saccate111311763saccate
sachets123914103sachets
sackbuts1644053sackbuts
sacrals93311793sacrals
sadists83310853sadists
sagas66025883sa_ga_s
sagbut959753sagbut_
saggars93610683saggars
saigas74114293saiga_s
sailboats1145243sailboats
saints65122423sa_ints
salaams997703salaams
salads75316963sa_lads
salals65120083sa_lals
sallets73719653sallets
salpas85116923salpa_s
salsas65316133salsa_s
salts55431883sa__lts
samba95618773samba__
sambaed1238303sambaed
sambal105215183samba_l
sambar103914163samba_r
sambhars1544833sambhars
sambos104315193samb_os
samburs11369343samburs
samlets93813553samlets
sampans112411003sampans
sandals82715203sandals
sandbags1296373sandbags
sandbars11108783sandbars
sangars83116253sangars
sangas75222653sanga_s
sanjaks1834963sanjaks
sansars73313913sansars
sapotas939613sapotas
sarans64224433sa_rans
sardars83112903sardars
sarsars73512143sarsars
sashays1336333sashays
satays94411683sa_tays
satiate7315403satiate
satiates8314633satiates
satraps95011643satraps
saults65816173sa_ults
saunas63915433sauna_s
savants1038653savants
savate9313783sa_vate
savates10312953sa_vates
scabbard1544203scabbard
scabbards1643763scabbards
scabbles14167983scabbles
scats75930603s__cats
scubas103710223scuba_s
seabags1037483seabags
seaboots1047093seaboots
seats54844343s__eats
shabbatot1652513shabbatot
shibahs15275643shibahs
shoats94117083s_hoats
sibbs96211903sibb__s
skats94621543s__kats
slabbers123610123slabbers
slats55436903s__lats
sobas74424253s_oba_s
sobbers114114263sobbers
sorbate9311733sorbate
sorbates10311103sorbates
sorbets93012513sorbets
spambots1443313spambots
spats75031383s__pats
splats84817303s_plats
sprats85819933s_prats
squats153712963s_quats
stabbers12268733stabbers
stats55933363s__tats
stoats65117483s_toats
subabbots1241873subabbots
subahs114512383s_ubahs
subas74724073s_uba_s
subbase1139323subbase
subbases1239063subbases
sublate9315363sublate
sublates10315003sublates
sublets92616703sublets
sublots92410913sublots
submits1139753submits
subnets92512083subnets
subparts1246903subparts
subsets92813103subsets
subways1536163subways
sunbath1236423sunbath
sunbaths1344383sunbaths
swabbers15316743swabbers
swabbies15115713swabbies
swats85726863s__wats
sweats94814613s_weats
tabbies112913503tabbies
tabbis102910863tabb_is
tablas83716163tabla_s
tablets94714383tablets
tambacs13219363tambacs
tambaks15218153tambaks
upbeats1195733upbeats
wabbles144013993wabbles
wombats1435893wombats
yabbers14389353yabbers
yabbies14279643yabbies
zaibatsu194843zaibatsu

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.406440125.6
2DLD Change Limit1340272537.29618369.9
3Display Results2532530.0962635.4
 (SQL Overall)1786912537.79822915.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.