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

248 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
skatol103572(None) 
skatole1135691skatole
skatols1135531skatols
amatol838692amatol
ketol95414002_ketol
salol55222142s_alol
santol64515242santol
skat87037902skat__
skate94721552skat_e
skated114414882skated
skater105015492skater
skates104219402skates
skatoles1236142skatoles
skats94621542skat_s
sotol54917652s_otol
stanol6310722stanol
statal61613222statal
stator64015482stator
abator84512733abator
amatols938183amatols
atoll57913923__atoll
atom67824523__atom
atop66124753__atop
awol75620673__awol
baton75822423_baton
boatel84314093boatel
carol75128613_carol
craton84517193craton
dato56129943_dato_
datos65222783_datos
diatom939453diatom
espanol943783espanol
extol1247893_extol
fatal84819373_fatal
gaol56925413_ga_ol
gator64416043_gator
hiatal9310203hiatal
ikat87626653ikat__
ikats95311153ikat_s
jato115822683_jato_
jatos125116823_jatos
kabob134113933_kabob
kail85131503_ka_il
kaon87521033_ka_on
kapok10448783_kapok
karoo92519593_karoo
kat77468303_kat__
kata85626043_kat_a
katas95922103_katas
kation104315683_kation
kats85944343_kat_s
kayo116417563_kayo_
kayos127714703_kayos
kazoo183311533_kazoo
keto86223463_keto_
ketols104210763_ketols
koto86323483_koto_
kotos95717703_kotos
kotow12528713_kotow
lintol6369473lintol
maltol8310843maltol
meatal84114733meatal
metol75917813_metol
natal53921493_natal
orator6314533orator
parol74826273_parol
patrol83213023_patrol
phytol14366563phytol
pistol83313333pistol
ratal55025113_ratal
ratel54224883_ratel
rato45436973_rato_
ratos55528773_ratos
sabal75422483s_abal
sabaton937713sabaton
sabot7931783s_abot
sacaton938993sacaton
safrol937283safrol
sago56332673s_ago_
sagos66123873s_agos
sail45447163s_a_il
sajou12311693s_ajou
sal36462883s_a__l
salal55425703s_alal
sall44544683s_a_ll
salols64017873s_alols
salon55228553s_alon
santo56227283santo_
santols73513323santols
santos64421833santos
sapor75119253s_apor
sarod65325873s_arod
saros55238063s_aros
sartor6313883sartor
sat36288483s_at__
satay84718463s_atay
sate45556103s_at_e
sated66238533s_ated
satem76021463s_atem
sates54949323s_ates
sati45539333s_at_i
satin55935223s_atin
satis55633683s_atis
satori6415843s_atori
satyr848483s_atyr
saul45836523s_a_ul
savor85417943s_avor
savoy114713883s_avoy
scall74420373sca_ll
scat65848373scat__
scathe114414993scathe
scats75930603scat_s
scatt76030093scat_t
scatts85914663scatts
scatty115310653scatty
school11410723school
seadog838743seadog
seafowl1343913seafowl
seal45654373sea__l
season62714903season
seat47575563seat__
seated75131063seated
seater64534163seater
seats54844343seat_s
sector83415933sector
senator7313073senator
septal84513383septal
setal56430903s_etal
seton55223543s_eton
sexto124415453sexto_
sexton133610793sexton
sextos134012163sextos
shadow1337253shadow
shako125516093shako_
shakos134912193shakos
shall85024053sha_ll
shalom11810923shalom
shamos114216983shamos
shamoy14379913shamoy
shat76456603shat__
shaul85418103sha_ul
shawl116217573sha_wl
sheol84318373s_heol
shool84523153s_hool
sial45938843sia__l
ska76925863ska___
skag96321513ska__g
skags104316073ska_gs
skald104210173ska_ld
skalds11437833skalds
skank84415583ska_nk
skanks94710833skanks
skanky12476963skanky
skas85325713ska__s
skaters113512963skaters
skating123613853skating
skell94915833sk_ell
sketch1535363sketch
skibob1433423skibob
skidoo1136103skidoo
skill94316733sk_ill
skimo116312553skimo_
skimos12548803skimos
skirl96012923sk_irl
skit85437543skit__
skite95120063skit_e
skited114313483skited
skites104418043skites
skits94721873skit_s
skittle1135533skittle
skoal93811463sk_oal
skull94812033sk_ull
skybox2242293skybox
slalom888173slalom
slat46959023slat__
slatch114510533slatch
slate55438283slat_e
slated75028313slated
slater64429183slater
slates64934063slates
slatey95417063slatey
slats55436903slat_s
slaty86523153slat_y
small74016263sma_ll
smalto84410283smalto_
smaltos9408193smaltos
snail57020203sna_il
snarl54921083sna_rl
snatch114310603snatch
snath86419803snat_h
snathe94415113snathe
snaths95112913snaths
snool55118643s_nool
sokol94612293s_okol
sol37256623s___ol
sotols63714473s_otols
spado83713703spado_
spail74921553spa_il
spall74919303spa_ll
spat66548523spat__
spate74731583spat_e
spates85028173spates
spathal1236263spathal
spathe115115693spathe
spatial9310323spatial
spats75031383spat_s
spatula935903spatula
spatzle1834583spatzle
spital83813873spital
spool75219043s_pool
stall54722353sta_ll
stanols739733stanols
stat47352693stat__
state56237333stat_e
stated75427833stated
stately10310223stately
stater64427563stater
states64337083states
static83118683static
statin63921473statin
station72717243station
stators73915583stators
stats55933363stat_s
statue66015323statue
status65515213status
sterol6613333sterol
stoa45425913s__toa
stob66724613s__tob
stole54928813s__tole
stool55619893s_tool
stop66532033s__top
stot46347333s__tot
stow77325743s__tow
stratal72710603stratal
subatom1147053subatom
suitor63311053suitor
swail86217163swa_il
swat77244443swat__
swatch14549283swatch
swath115920383swat_h
swathe125514113swathe
swaths125312643swaths
swats85726863swat_s
symbol1336083symbol
systole1035763systole
taxol124011363_taxol
viator93211843viator
wittol935923wittol

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.390458182.1
2DLD Change Limit1127162485.31321215.1
3Display Results2482480.0763263.2
 (SQL Overall)1786912485.77930920.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.