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

199 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
skatols113553(None) 
skatol1035721skatol_
skatole1135691skatole
skatoles1236141skatoles
amatols938182amatols
ketols104210762_ketols
salols64017872s_alols
santols73513322santols
skaters113512962skaters
skates104219402skat_es
skats94621542skat__s
sotols63714472s_otols
stanols739732stanols
stators73915582stators
abators94413083abators
amatol838693amatol_
atoll57913923__atoll
atolls65511353__atolls
atoms76817563__atoms
awols84713523__awols
batons85519423_batons
boatels93510233boatels
carols85124983_carols
cratons94316033cratons
datos65222783_dato_s
diatoms1039073diatoms
extols1337683_extols
gaols66717573_ga_ols
gators74115833_gators
ikats95311153ikat__s
jatos125116823_jato_s
kabobs14439303_kabobs
kails95525213_ka_ils
kaons95014853_ka_ons
kapoks11347263_kapoks
karoos102415803_karoos
kaross101910013_kaross
katas95922093_kat_as
kations114013663_kations
kats85944333_kat__s
kayoes134710823_kayoes
kayos127714703_kayo_s
kazoos19259113_kazoos
ketol95414003_ketol_
kotos95717703_koto_s
kotows13446523_kotows
lintols7339553lintols
maltols939403maltols
metols84115773_metols
orators7313823orators
parols84722613_parols
patois84319363_patois
patrols93513513_patrols
phytols15276553phytols
pistols93213983pistols
ratals64219583_ratals
ratels64518213_ratels
ratos55528763_rato_s
sabals84618863s_abals
sabatons1037843sabatons
sabots8314703s_abots
sacatons1038973sacatons
safrols1036863safrols
sagos66123873s_ago_s
sails55738103s_a_ils
sajous13310583s_ajous
salals65120083s_alals
salol55222143s_alol_
salons63823693s_alons
sals46851673s_a__ls
santol64515243santol_
santos64421833santo_s
sapors84118813s_apors
sarods74918573s_arods
saros55238063s_aro_s
sartors7314973sartors
satays94411683s_atays
sates54949323s_at_es
satins64930483s_atins
satis55633683s_at_is
satori6415843s_atori
satoris7317253s_atoris
satyrs937963s_atyrs
sauls55128123s_a_uls
savors95616103s_avors
savoys12427893s_avoys
scalls84218203sca_lls
scathes124515713scathes
scats75930603scat__s
scatts85914663scat_ts
schools1249113schools
seadogs958643seadogs
seafowls1443663seafowls
seals54839693sea__ls
seasons72614233seasons
seaters74028943seaters
seats54844343seat__s
sectors93116453sectors
senators8312953senators
setons64620173s_etons
setous64917373s_etous
sextons143710413sextons
sextos134012163sexto_s
shadows1437193shadows
shakoes144510023shakoes
shakos134912193shako_s
shaloms1288983shaloms
shamois123210423shamois
shamos114216983shamo_s
shamoys15367283shamoys
shauls94913113sha_uls
shawls125411973sha_wls
sheols94614163s_heols
shools94919013s_hools
sials54227243sia__ls
skags104316073ska__gs
skald104210173ska__ld
skalds11437833ska_lds
skanks94710833ska_nks
skas85325713ska___s
skat87037903skat___
skate94721553skat__e
skated114414883skat_ed
skater105015493skat_er
skating123613853skating
skatings13326993skatings
skells105013783sk_ells
skibobs1542993skibobs
skidoos1234463skidoos
skills104313923sk_ills
skimos12548803skimo_s
skirls10449823sk_irls
skites104418043skit_es
skits94721863skit__s
skittle1135533skittle
skittles1245763skittles
skoals10438243sk_oals
skulls10429643sk_ulls
slaloms9106543slaloms
slaters73123733slaters
slates64934063slat_es
slats55436903slat__s
smalls84514123sma_lls
smaltos9408193smalto_s
snails64816653sna_ils
snarls64016873sna_rls
snathes104816493snathes
snaths95112913snat_hs
snools65715883s_nools
sokols10399093s_okols
sols45448163s___ols
sotol54917653s_otol_
spails84817823spa_ils
spalls84217343spa_lls
spates85028173spat_es
spathes125116533spathes
spats75031383spat__s
spatula935893spatula
spatulas1045473spatulas
spatzle1834583spatzle
spatzles1935303spatzles
spitals93011593spitals
spools85115913s_pools
stalls64019933sta_lls
stanol6310723stanol_
statal61613223statal_
stately10310223stately
staters73922343staters
states64337083stat_es
statics93314533statics
statins73719773statins
stations82415223stations
stator64015483stato_r
stats55933363stat__s
statues74614903statues
status65515213stat_us
sterols7313443sterols
stoas55126023s__toas
stobs75718233s__tobs
stole54928813s__tole
stoles63927673s__toles
stools65117023s_tools
stops74827283s__tops
stoss54316343s__toss
stots54828553s__tots
stows86622703s__tows
stratous8410703stratous
subatoms1245883subatoms
suitors73012493suitors
swails94913123swa_ils
swathes134115513swathes
swaths125312643swat_hs
swats85726863swat__s
symbols1435523symbols
systole1035763systole
systoles1146483systoles
taxols13328633_taxols
viators102712023viators
wittols1035733wittols

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271995.92022639.7
3Display Results1991990.0633158.7
 (SQL Overall)1786911996.37628025.6
 
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.