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

505 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
satori641583(None) 
satoris7317231satoris
gator64416032gator_
gators74115822gators
safari91110222safari
sapor75119252sapor_
sapors84118812sapors
sari45444042sa__ri
sartor6313872sartor_
sartorii845572sartorii
sartors7314952sartors
satara6315532satara
sati45539322sat__i
satire63218002satire
satiric939242satiric
satyr848482satyr_
satyric1237492satyric
satyrid1137232satyrid
satyrs937962satyrs
sautoir735162sautoir
savor85417942savor_
savors95616102savors
savory124310562savory
sori46039832s__ori
stator64015472stator_
stators73915552stators
stoai55417862s_toai
store56333812s_tore
stork96819692s_tork
storm76520372s_torm
story86723032s_tory
tori47542152__tori
abator84512713abator_
abators94413073abators
abort76133583_abort
abri65522213_a_bri
acari75020283_acari
acorn75616623_acorn
actor71116073actor_
actors81016753actors
adore65723663_adore
adorn64917093_adorn
afore85818603_afore
agora6914333_agora
aioli5318313_aioli
amatory1238613amatory
amort75832203_amort
aporia8315863_aporia
aport75432173_aport
ashore9414613ashore
askoi9507793asko_i
assort64916373assort
aster55434893aster_
asteria7316173asteria
astern64815813astern
asters65631603asters
astir55517093astir_
astony9510523astony
atoll57913923_atoll
atom67824523_ato_m
atomic104115603_atomic
atoms76817563_atoms
atomy107415193_atomy
atone56527983_atone
atonia63816513_atonia
atonic83420473_atonic
atony87218853_atony
atop66124753_ato_p
atopic103514143_atopic
atopy106813393_atopy
atria56022333_at_ria
atrip75315743_at_rip
attorn6310793attorn
attrit6315743_attrit
baton75822423bato_n
batons85519423batons
caloric113413213caloric
calorie92716883calorie
calory11312843calory
cantor85621523cantor_
cantors94620753cantors
captor104914603captor_
captors113914983captors
caroli85918233caroli
castor84418533castor_
castors94919433castors
cater74840703cater_
caters85336493caters
cavort11316173cavort
datary10310243datary
dater65332313dater_
daters74827363daters
dato56129943dato__
datos65222783dato_s
datura738023datura
daturic1047003daturic
eater54639843eater_
eaters65535943eaters
eatery95316353eatery
ephori1139603ephori
extort13513973extort
factor11911453factor_
factors12912123factors
factory15108343factory
favor114712453favor_
favors124211403favors
fetor81214533fetor_
fetors91014473fetors
galore73514843galore
gater64533643gater_
gaters74728633gaters
hater85034753hater_
haters94930393haters
iatric8312153iat_ric
intort6418923intort
jato115822683jato__
jatos125116823jato_s
kauri93811843ka_uri
laari54415713la_ari
labor75117313labor_
labors84016403labors
lari45839153la__ri
later54843923later_
lathi85417203lat_hi
lati46438273lat__i
latria62313583lat_ria
major145212923major_
majors154511093majors
maloti8313193maloti
manor78023923manor_
manors84420883manors
mater74438863mater_
maters85032383maters
matrix1539833mat_rix
matron83918313matron
mature8313463mature
mayor106616623mayor_
mayors115714193mayors
motor75317293motor_
motoric11312223motoric
motors84616593motors
naoi46024633na_o_i
natron64116023natron
nature6311263nature
nori47133143__nori
oater55433733oater_
oaters65029783oaters
octopi1036533octopi
octroi837363octroi
orator6314533orator_
oratorio845633oratorio
orators7313803orators
oratory1039403oratory
padri85815163pa_dri
pakora1247283pakora
papyri1334903papyri
pastor84817483pastor_
pastors94118993pastors
pater74740723pater_
paters84935823paters
patois84319363patois
patrol83213023patrol
patron84018043patron
payor105413843payor_
payors114312643payors
poori74816233_poori
pylori1147163pylori
raptor83912823raptor_
raptors94213353raptors
rater54943283rater_
raters63936573raters
rato45436973rato__
ratoon64417373ratoon
ratos55528763rato_s
razor143012603razor_
razors154711653razors
retore67630763retore
retorn610923423retorn
retort66831143retort
rotor55519733rotor_
rotors64917933rotors
saber75330243saber_
sabers85224733sabers
sabir75916993sabir_
sabirs85414623sabirs
sabot7931773sabo_t
sabots8314693sabots
sabra75317853sa_bra
sabre74821503sa_bre
sacra74516993sa_cra
sadi55834643sa__di
safaris101110663safaris
safer84721813safer_
safrol937283safrol
sager65432053sager_
sago56332673sago__
sagos66123873sago_s
sailor63113743sailor_
sailors73213713sailors
sajou12311693sajo_u
sajous13310583sajous
saker95132023saker_
sakers104125433sakers
saki85628473sa__ki
salami8313103salami
salary9515213salary
salmi7815863sa_lmi
salol55222143salo_l
salols64017873salols
salon55228553salo_n
salons63823683salons
saloon64418023saloon
saloop84212583saloop
salter64325083salter_
saltern74010653saltern
salters73622253salters
saltire73113033saltire
saltwork1545533saltwork
saltwort1148593saltwort
saluki1036203saluki
salvor94711093salvor_
salvors103910903salvors
samara8313853samara
samosa8510203samosa
samurai945923samurai
sanatoria947143sanatoria
sandhi1038193sandhi
saner54334323saner_
sangria838113sangria
sanitoria946653sanitoria
sansei63411903sansei
santera7311303santera
santeria8311643santeria
santero7311133santero
santimi938783santimi
santir6315243santir_
santirs7312963santirs
santo56227283santo__
santol64515243santo_l
santols73513323santols
santonin849693santonin
santoor737433santoor
santoors837633santoors
santos64421833santo_s
santour737373santour
santours837173santours
santur6311273santur_
santurs7310763santurs
saponin9310253saponin
sapota8310203sapota
sapote8314353sapote
sapour83812373sapour
sapours93610613sapours
sard55344243sa__rd
sarin55239253sa__rin
saris54544953sa__ris
sark84938973sa__rk
sarod65325873saro_d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
sartorial948383sartorial
sartorius947163sartorius
sat36288483sat___
satang75711563satang
satanic939933satanic
sataras7315053sataras
satay84718463sat_ay
satays94411683satays
sate45556103sat__e
sated66238533sat_ed
sateen63815013sateen
satem76021453sat_em
sates54949323sat_es
satin55935213sat_in
sating74735453sating
satins64930483satins
satiny93817983satiny
satires72617573satires
satirise8310683satirise
satirist8313503satirist
satirize1749693satirize
satis55633673sat_is
satrap86212553satrap
satyrids1245623satyrids
saury84317223sa_ury
sautoire844493sautoire
sautoirs834923sautoirs
savarin10310003savarin
saver84831253saver_
savers93825923savers
savior9710173savior_
saviors1058993saviors
savored1158343savored
savorer1057883savorer
savorier1136643savorier
savories11311273savories
savorily1445043savorily
savoring1269483savoring
savour94110703savour
savours10389333savours
savoury13365873savoury
savoy114713883savo_y
savoys12427893savoys
sawer85026213sawer_
sawers94620163sawers
saxhorn1744223saxhorn
saxony1636233saxony
sayer84926553sayer_
sayers94221593sayers
schorl1179803schorl
score75526733s_core
scoria8513483s_coria
scorn75817443s_corn
seaport9315593seaport
seater64534153seater_
seaters74028933seaters
seatwork1546773seatwork
sector83415923sector_
sectors93116433sectors
senator7313063senator_
senators8312943senators
senor53822793senor_
senora63216153senora
senors63620783senors
setoff1238913setoff
seton55223543seto_n
setons64620173setons
setose65114773setose
setous64917373setous
setout64719463setout
shogi95013993s_hogi
shoji15419943s_hoji
shore85432643s_hore
shorl84720243s_horl
shorn85722173s_horn
short85040523s_hort
shri76021693s__hri
signori8347893signori
sitar54820543sitar_
sitars65417593sitars
skater105015483skater_
skaters113512943skaters
skatol1035713skato_l
skatole1135683skatole
skatols1135523skatols
skort94925633s_kort
slater64429183slater_
slaters73123723slaters
snore55424953s_nore
snort54833753s_nort
soli46637003s__oli
somoni8310733somoni
sopor74016493sopor_
sopors85215193sopors
sora45746913s__ora
sorb68333043s__orb
sord56237203s__ord
sore47059533s__ore
sorn46641063s__orn
sort46264813s__ort
sotol54917643soto_l
sotols63714453sotols
souari6311373souari
splore81611303splore
spoor75016353spoor_
spoors84014023spoors
spore75428593s_pore
sport75935983s_port
sri35634003s___ri
stair54719933stair_
stairs65416333stairs
star48037763s_tar_
stare54440263s_tare
stark95425623s_tark
starry94911673starry
stars55836573s_tars
start55642313s_tart
stater64427553stater_
staters73922323staters
stature74410673stature
stere55328543s_tere
steric8317063s_teric
stern55319123s_tern
stir45723243s_tir_
stirk95717413s_tirk
stirp76815503s_tirp
stirs55921613s_tirs
stoa45425913s_to_a
stoae55024263s_toae
stoas55126023s_toas
stoat57135953s_toat
stob66724613s_to_b
stobs75718233s_tobs
stock114417563s_tock
stogie7311313s_togie
stogy95414083s_togy
stoic7317243s_toic
stoke94922513s_toke
stole54928813s_tole
stolid74213173s_tolid
stoma75918273s_toma
stomp95616663s_tomp
stone55431183s_tone
stony85818643s_tony
stood65517713s_tood
stook95218213s_took
stool55619893s_tool
stoop75821543s_toop
stop66532033s_to_p
stope74727243s_tope
stops74827283s_tops
stopt76528353s_topt
storax1389783s_torax
stored75524213s_tored
storer64721673s_torer
stores65533643s_tores
storey95217613s_torey
storied8515163s_toried
stories7324273s_tories
storing83921123s_toring
storks106115933s_torks
storms85814603s_torms
stormy115510723s_tormy
stoss54316343s_toss
stot46347323s_to_t
stotin63215043s_totin
stots54828543s_tots
stott56929783s_tott
stoup75517073s_toup
stour54916743s_tour
stoure64814943s_toure
stourie7469343s_tourie
stours65015623s_tours
stoury9529943s_toury
stout57434053s_tout
stove85220253s_tove
stow77325743s_to_w
stowp105614233s_towp
stows86622703s_tows
stria55723203s_t_ria
strip77524333s_t_rip
strop77422243s_trop
strow88920573s_trow
stroy87720393s_troy
sturt56028963s_turt
styli83911173s_tyli
suasory1046043suasory
suborn8310003suborn
sudatoria1044063sudatoria
sudatory1245843sudatory
sudor6312623sudor_
sudors7311093sudors
suitor63311053suitor_
suitors73012473suitors
sutra54217933sut_ra
suture6313203suture
sword95214113s_word
swore84920813s_wore
sworn86115303s_worn
tabor75518393tabor_
taborin92210453taborin
tabors84517093tabors
tamari8313383tamari
tatami839183tatami
tatar56122063tatar_
tatars64619793tatars
tater54138613tater_
taters64932193taters
tatsoi637263tatsoi
tetri52716453tet_ri
topi67830393__topi
tor39261683__tor_
tora47545993__tora
torc66333353__torc
tore47359323__tore
toric76529313__toric
torii55521593__torii
torn46044253__torn
toro48045683__toro
torr45630903__torr
tors46157383__tors
torsi57423363__torsi
tort46967463__tort
tory75840543__tory
tutor5712493tutor_
tutors6912323tutors
uakari1046863uakari
untorn63012343untorn
uptore8279453uptore
uptorn8268093uptorn
uteri51012983_uteri
valor83614893valor_
valors93413773valors
vapor104013093vapor_
vapors113812693vapors
vapory14398763vapory
viator93211833viator_
viators102712013viators
water84733313water_
waters95030623waters
watery123914493watery
yakitori1542423yakitori
zori137722923__zori

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.1401276364.3
2DLD Change Limit1127165055.55020309.2
3Display Results5055050.1702970.6
 (SQL Overall)1786915055.86030493.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.