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

301 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
sabbat1031471(None) 
sabbath1445391sabbath
sabbats1138631sabbats
abba810522652_abba_
abbas95918642_abbas
abbot9318452_abbot
gabbart1248882gabbart
rabat72832222ra_bat
rabbet103818652rabbet
rabbit102914562rabbit
sabal75422482sa_bal
sabbaths1543972sabbaths
sabbatic1445322sabbatic
sabbed114518082sabbed
sabot7931782sa_bot
sabra75317852sabra_
sabras85116362sabras
sacbut10811942sacbut
sagbut959752sagbut
samba95618772samba_
sambal105215182sambal
sambar103914162sambar
sambas104219262sambas
aba512850953_a_ba_
abaft10318063_abaft
abas68642083_a_bas
abate76627843_a_bate
abbacy1536623_abbacy
abbe87627193_abb_e
abbes96723523_abbes
abbey125714933_abbey
abbots1039283_abbots
abeam9316533_abeam
abet610547943_a_bet
ablate82219213_ablate
ablaut8313263_ablaut
abort76133583_abort
about75229083_about
abut66834953_a_but
abwatt11410673_abwatt
alba68328333_alba_
albas75925393_albas
albata839333_albata
ambit94223713_ambit
arhat8327093_arhat
baba88828353ba_ba_
babas96325733ba_bas
babbitt1038033babbitt
babble94017113babble
babka137812913babka_
babkas146010143babkas
babysat14135233babysat
baobab946403baobab
barbal104016663barbal
barbate11314543barbate
barbet104427883barbet
barbut104617003barbut
bat510988953___bat
beat66168303__beat
blat66550953__blat
boat66360313__boat
bobcat12411253bobcat
brat66055543__brat
bubba84311803bubba_
bubbas94110703bubbas
cabal95222153ca_bal
cabbage1446983cabbage
cabbagy1744013cabbagy
cabbala1367183cabbala
cabbed135416263cabbed
cabbie122913353cabbie
cabby145314563cabb_y
cablet104429463cablet
cabman123812503cabman
carat75048793ca_rat
casbah1337903casbah
catboat11412243catboat
caveat11417723caveat
combat12316753combat
dabbed124416143dabbed
dabber114816963dabber
dabble114515193dabble
darbar959953darbar
drabbet12319573drabbet
ebbet93517293_ebbet
fabber134814113fabber
fabbest1438033fabbest
gabbard1336553gabbard
gabbarts1344063gabbarts
gabbed125216893gabbed
gabber114916603gabber
gabble113815723gabble
gabbro11114953gabbro
gabby135512953gabb_y
gamba106018513gamba_
gambas115817513gambas
gambit114714213gambit
gasbag1035413gasbag
gibbet114113383gibbet
gobbet114214443gobbet
habit103027023ha_bit
habitat12411053habitat
hagbut1278923hagbut
hazmat20312263hazmat
hobbit132810543hobbit
jabbed184213483jabbed
jabber173713643jabber
jabot14321513ja_bot
jubbah2034353jubbah
kabab134814443ka_bab
kababs14409773kababs
kabar114815553ka_bar
kabbala1584613kabbala
kanban1238623kanban
karat96837593ka_rat
kasbah1535183kasbah
labia75219013labia_
labial84714343labial
labiate91313573labiate
labra75415463labra_
labret8320223labret
lambast11129893lambast
lariat6629043lariat
mamba116317523mamba_
mambas125716243mambas
manat76039993ma_nat
nabbed115113613nabbed
nabber104913543nabber
numbat10312083numbat
qanat144426843qa_nat
rabato83413263ra_bato
rabats83116223ra_bats
rabbets11279423rabbets
rabbi93113183rabb_i
rabbin103112303rabbin
rabbis102613163rabbis
rabbits11299863rabbits
rabbity14266303rabbity
rabble103818243rabble
ragbag1045463ragbag
ratbag956563ratbag
sab56563203sa_b__
sabals84618863sabals
sabaton937713sa_baton
sabbatics1543393sabbatics
sabbing123314743sabbing
sabe66140573sa_b_e
sabed86526813sa_bed
saber75330243sa_ber
sabers85224733sabers
sabes76437463sa_bes
sabin74924953sa_bin
sabine84020393sabine
sabins85521983sabins
sabir75917003sa_bir
sabirs85414633sabirs
sable74732163sa_ble
sables85026693sables
sabots8314703sabots
sabre74821503sa_bre
sabred95916533sabred
sabres85520863sabres
sabs66643743sa_b_s
sacbuts1166473sacbuts
saccate111311763saccate
sachet114725773sachet
sackbut1545943sackbut
sacra74516993sacra_
sacral83414413sacral
sadist74221353sadist
safest95016603safest
saga55331173sa_ga_
sagas66025883sa_gas
sagbuts1065223sagbuts
sagest74920263sagest
saggar84010853saggar
saiga64717933saiga_
saigas74114293saigas
sailboat1047693sailboat
saint55147073sa_int
salaam8711013salaam
salad65321833sa_lad
salal55425703sa_lal
sallet63734543sallet
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salsa56718923salsa_
salsas65316133salsas
salt45758523sa__lt
saltant7316773saltant
sambaed1238303sambaed
sambals115213483sambals
sambars115113843sambars
sambhar1444853sambhar
sambo95118013samb_o
sambos104315193sambos
sambur10469503sambur
samlet84126563samlet
sampan102511893sampan
sancta839833sancta
sandal73317283sandal
sandbag11106243sandbag
sandbar10108193sandbar
sanest64426693sanest
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
sanjak1735693sanjak
sansar63613393sansar
sapota8310213sapota
saran53730303sa_ran
sardar73013173sardar
sarsar63011843sarsar
sashay1238363sashay
sat36288483s___at
satay84718463sa_tay
satiate7315403satiate
satrap86212553satrap
sault55834963sa_ult
sauna54117553sauna_
saunas63915433saunas
savant9416043savant
savate9313783sa_vate
sayest94217743sayest
sayst85322003sa_yst
scabbard1544203scabbard
scabbed14408223scabbed
scabble13168653scabble
scabby1535503scabb_y
scat65848373s__cat
scuba94211593scuba_
scubas103710223scubas
seabag938473seabag
seaboot9512333seaboot
seat47575563s__eat
shabbatot1652513shabbatot
shabby1635803shabb_y
shat76456603s__hat
shibah14387473shibah
shoat85633953s_hoat
sibb85921423sibb__
sibbs96211903sibb_s
skat87037903s__kat
slabbed12409503slabbed
slabber113311393slabber
slat46959023s__lat
soba64927923s_oba_
sobas74424253s_obas
sobbed113516263sobbed
sobber104016593sobber
sobeit8315363sobeit
sorbate9311733sorbate
sorbet83924083sorbet
spambot1345913spambot
spat66548523s__pat
splat76129343s_plat
sprat76635973s_prat
squat143720143s_quat
stabbed123510373stabbed
stabber113610153stabber
stat47352693s__tat
stoat57135953s_toat
suba64926603s_uba_
subabbot1143133subabbot
subah106015213s_ubah
subas74724073s_ubas
subbase1139323subbase
subbass1138033subbass
subbed114116673subbed
sublate9315363sublate
sublet82827243sublet
sublot82315523sublot
submit10312673submit
subnet82520933subnet
subpar1048663subpar
subpart11311123subpart
subset83122583subset
subway1447073subway
sunbath1236423sunbath
swabbed15367403swabbed
swabber14297963swabber
swabbie1484333swabbie
swabby1634353swabb_y
swat77244443s__wat
sweat85628403s_weat
tabbed114215363tabbed
tabbis102910863tabbis
tabby125213893tabb_y
tabla73318363tabla_
tablas83716163tablas
tablet84227643tablet
tambac122210243tambac
tambak14249263tambak
upbeat10911513upbeat
wabble133714843wabble
wabbly16348363wabbly
wombat1339863wombat
yabber136111833yabber
yabbie13308663yabbie
yabby15389753yabb_y

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163015.12621989.1
3Display Results3013010.0933236.6
 (SQL Overall)1786913015.59231954.8
 
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.