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

433 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
satrap8621255(None) 
satraps95011641satraps
satrapy12497931satrapy
strap77925261s_trap
astral66919282astral
astray95615542astray
atap66722452_at_ap
atrip75315752_atrip
caltrap11297942caltrap
cantrap113310282cantrap
catnap1098382catnap
entrap8710562entrap
mantrap11379822mantrap
rattrap945262rattrap
sabra75317852sabra_
sabras85116362sabras
sacra74516992sacra_
sacral83414412sacral
saran53730302sa_ran
sarape84817572sa_rape
satara6315532satara
sataras7315062sataras
satay84718462sat_ay
scrap97120402s_crap
straps87721782s_traps
straw813321292s_traw
stray88525572s_tray
strep77120852s_trep
strip77524342s_trip
strop77422242s_trop
sutra54217932sutra_
sutras64818592sutras
trap67532802__trap
watap102111672wat_ap
amtrac10109123amtrac
antra56521923antra_
antral65719413antral
arak86929573_a_rak
arras55626133_arras
array86317143_array
artal55525473_artal
ashram1139053ashram
ashtray13805553ashtray
astrals75515243astrals
ataps76414833_at_aps
atlas55821583_atlas
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
atop66124753_at_op
atria56022343_atria
atrial65418943_atrial
attar56516693_attar
aura45836253_aura_
aurae54128113_aurae
aural54428963_aural
aurar54420253_aurar
auras55932563_auras
bateau8810563bateau
batman105214063batman
betray111511443betray
bewrap13157053bewrap
bitmap1235613bitmap
caltraps12327253caltraps
caltrop11267643caltrop
cantraip12326393cantraip
cantraps12319113cantraps
cantrip112910043cantrip
carat75048793ca_rat
carp85139813ca_r_p
cartop104213563cartop
cateran9313773cateran
catnaps1197033catnaps
catnip1097973catnip
catsup1036433catsup
citral81113893citral
claptrap1442903claptrap
crap85731843__crap
data56026653dat_a_
datary10310243datary
datura738023datura_
daturas838773daturas
earlap837183earlap
entraps9109763entraps
enwrap1185213enwrap
estral64716513estral
estray95713333estray
extra1239003extra_
extras13310223extras
farad95720673fa_rad
fatal84819373fat_al
fatwa1168063fatwa_
fatwas1249053fatwas
flatcap1463653flatcap
flytrap1543253flytrap
frap95925813__frap
gastral8329553gastral
gateau778113gateau
haircap14134753haircap
harp96134293ha_r_p
hartal9415473hartal
hatrack1638213hatrack
hatred104814333hatred
iatric8312163iatric
inwrap11115903inwrap
jagra1338173jagra_
jagras1438463jagras
jalap143612473ja_lap
jarrah1636683jarrah
karat96837593ka_rat
kata85626023kat_a_
katas95922093kat_as
labra75415463labra_
larrup835713larrup
laterad8310843laterad
lateral7313573lateral
latria62313593latria
latrias71913213latrias
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
madcap1336333madcap
madras94316433madras
mantra84116093mantra_
mantram114011603mantram
mantraps12298063mantraps
mantras93815863mantras
mara67444573ma_ra_
maras75443293ma_ras
marram10313883marram
matrass939403matrass
matres84522233matres
matrix1539843matrix
matron83918313matron
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
mayhap1635233mayhap
mitral81314323mitral
naira5314743naira_
nairas6312783nairas
natal53921493nat_al
natron64116023natron
natural739513natural
osetra667423osetra_
osetras737323osetras
outran63218893outran
para65242173pa_ra_
parae76335703pa_rae
paraph13311263pa_raph
paras76143043pa_ras
parral85517533parral
partan83820563partan
patrol83213023patrol
patron84018043patron
petnap1037423petnap
rap56261963___rap
ratal55025113rat_al
ratan53722663rat_an
ratbag956563ratbag
rattan63613603rattan
rattraps1044823rattraps
retral64419743retral
rewrap11127533rewrap
riprap1055513riprap
sabal75422483sa_bal
sabbat10314713sabbat
sabre74821503sabr_e
sabred95916533sabred
sabres85520863sabres
sacrals93311793sacrals
sacred94917103sacred
sacrum103910143sacrum
safari91110223safari
safrol937283safrol
saga55331173sa_ga_
sagas66025883sa_gas
saggar84010853saggar
saiga64717933saiga_
saigas74114293saigas
salaam8711013salaam
salad65321833sa_lad
salal55425703sa_lal
salary9515213salary
salep77022953sa_lep
saloop84212583saloop
salp64534093sa__lp
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salsa56718923salsa_
salsas65316133salsas
saltpan935303saltpan
samara8313853samara
samaras9312913samaras
samba95618773samba_
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
samp85733593sa__mp
sampan102511893sampan
samurai945923samurai
sandal73317283sandal
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
sanjak1735693sanjak
sannop837373sannop
sannup836563sannup
sansar63613393sansar
santera7311303santera_
santeras8311063santeras
sap56463233s___ap
sarans64224433sa_rans
sarapes94617743sa_rapes
sard55344243sa_r_d
sardar73013173sardar
sards64736183sa_rds
saree55044663sa_ree
sarge65531133sa_rge
sargo65424413sa_rgo
sari45444043sa_r_i
sarin55239253sa_rin
saris54544953sa_ris
sark84938973sa_r_k
sarks96632463sa_rks
sarky125521783sa_rky
sarod65325873sa_rod
saros55238063sa_ros
sarsar63011843sarsar
sartor6313883sartor
sashay1238363sashay
sat36288483sat___
satang75711563satang
satays94411683satays
sate45556103sat__e
sated66238533sat_ed
sateen63815013sateen
satem76021463sat_em
sates54949323sat_es
sati45539333sat__i
satiate7315403satiate
satin55935223sat_in
sating74735453sating
satins64930483satins
satiny93817983satiny
satire63218003satire
satires72617573satires
satiric939243satiric
satis55633683sat_is
satori6415843satori
satoris7317253satoris
satrapies1147713satrapies
saturant8410643saturant
saturate8312813saturate
satyr848483sat_yr
satyric1237493satyric
satyrid1137233satyrid
satyrs937963satyrs
sauna54117553sauna_
saunas63915433saunas
saurel6511993saurel
saurian739913saurian
saury84317223saur_y
scarab10310063scarab
scarp95724103scar_p
scrag85916173s_crag
scram910621623s_cram
scrape105917573s_crape
scraps106017243s_craps
scrip96619193s_crip
seatrain847923seatrain
sera46141393s_era_
serac75925203s_erac
serai56830163s_erai
seral56336383s_eral
serape84818413s_erape
seraph114011163s_eraph
seta45637313set_a_
setae56026223set_ae
setal56430903set_al
setup73915823set_up
sharp104922533shar_p
sherpa1138093sherpa
shoran94016043shoran
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
sirup74014913s_irup
sistra639333sistra_
sitar54820543sit_ar
sitars65417593sitars
situp74414063sit_up
skycap1742913skycap
slap66434043s__lap
slurp74014983slur_p
snap65727033s__nap
sneap75514823s_neap
soap65831133s__oap
sora45746913s_ora_
soras55041013s_oras
sorta57125413sorta_
sovran937153sovran
spartan948333spartan
spathal1236263spathal
spatial9310323spatial
spiral83715343spiral
sporal82915453sporal
sprag86418693s_prag
sprat76635973s_prat
spray106720063s_pray
stab67329933s_t_ab
stag57332003s_t_ag
stalag7310023stalag
stamp95217363s_tamp
staph104314653s_t_aph
star48037763s_t_ar
starch113013203starch
stare54440263star_e
stared75429873stared
starer64027363starer
stares66038753stares
stark95425623star_k
starry94911673starry
stars55836573star_s
start55642313star_t
starts65423123starts
startup934963startup
starve94613743starve
stat47352693s_t_at
statal61613223statal
staw78627693s_t_aw
stay78333723s_t_ay
stead65520273s_tead
steak95219803s_teak
steal56125473s_teal
steam76322933s_team
steep76020703s_teep
step67126293s_t_ep
stirp76815503s_tirp
stoa45425913s_toa_
stoae55024263s_toae
stoai55417873s_toai
stoas55126023s_toas
stoat57135953s_toat
stomp95616663s_tomp
stoop75821543s_toop
stop66532033s_t_op
storax1389783storax
stoup75517073s_toup
stowp105614233s_towp
strafe95215983s_trafe
strain64919573s_train
strait64025893s_trait
strake104017393s_trake
strand74514823s_trand
strang75718313s_trang
strappy14205263s_trappy
strass67117223s_trass
strata63616283s_trata
strath93216373s_trath
strati63518903s_trati
straws98718673s_traws
strawy1210312823s_trawy
strays96417933s_trays
streak104613623s_treak
stream84717293s_tream
streps86218063s_treps
strew89220663s_trew
stria55723213s_tria
striae65422273s_triae
stripe85822443s_tripe
strips85719653s_trips
stript85222193s_tript
stripy115812743s_tripy
strops86220383s_trops
strow88920573s_trow
stroy87720393s_troy
strum75619453s_trum
strut56030733s_trut
stump94616463s_tump
stupa74112313s_tupa
styrax1675243styrax
sunray9310123sunray
supra73614253supra_
sura45740293s_ura_
surah86823253s_urah
sural55931263s_ural
suras55336333s_uras
surra55521343surra_
surras65919533surras
surtax1337843surtax
sutta54015333sutta_
suttas63813793suttas
sutural7310223sutural
svaraj1634963svaraj
swap95925433s__wap
swaraj1636023swaraj
syrup103010963s_yrup
tagrag837043tagrag
tantra63713353tantra_
tantras73112093tantras
tap57663873__t_ap
tarp66936413ta_r_p
tartan64217513tartan
tartar63214753tartar
tatar56122063tat_ar
tatars64619793tatars
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
trad55630913__trad
tram67034553__tram
tramp96319773__tramp
traps75727483__traps
trapt76433393__trapt
tray77632593__tray
trip66830393__trip
trop66833303__trop
ultra539363ultra_
ultras6310193ultras
unstrap946783unstrap
unwrap11126323unwrap
vara75530883va_ra_
varas86028193va_ras
warp95635003wa_r_p
watape11208483wat_ape
wataps11248683wat_aps
wattape12135383wattape
wrap96821973__wrap
yantra9449623yantra_
yantras10259003yantras

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 Filter1786911127160.403443402.0
2DLD Change Limit1127164335.94018975.8
3Display Results4334330.1403092.9
 (SQL Overall)1786914336.48327563.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.