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

142 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
skatole113569(None) 
skatol1035721skatol_
skatoles1236141skatoles
skatols1135531skatols
skate94721552skat__e
skittle1135532skittle
spatzle1834582spatzle
stole54928812s__tole
systole1035762systole
amatol838693amatol_
amatols938183amatols
amole75724593__amole
anole55330383__anole
atoll57913923__atoll
atone56527983__atone
azole145118033__azole
battle85217863_battle
brattle9249253brattle
cajole154011183_cajole
cattle85118903_cattle
citole8311503_citole
diastole947563diastole
diazole1736793diazole
escarole1045743escarole
haole84820083_ha_ole
kale86533753_ka__le
kantele1138253_kantele
kathode1545733_kathode
ketol95414003_ketol_
ketols104210763_ketols
ketone105014533_ketone
ketose105711813_ketose
kettle104311613_kettle
kittle104012173_kittle
parole84425253_parole
pistole92414313pistole
prattle9208833prattle
rathole10312053_rathole
rattle64717613_rattle
sable74732163s_a_ble
saddle83915493s_addle
safrole1037253safrole
sale44959703s_a__le
salol55222143s_alol_
salols64017873s_alols
sample104215013s_ample
santol64515243santol_
santols73513323santols
sapote8314363s_apote
sarode75317513s_arode
sate45556103s_at__e
satire63218003s_atire
satori6415843s_atori
saxatile1544953saxatile
scabble13168653scabble
scale74629143sca__le
scapose1147753scapose
scathe114414993scat_he
scuttle936463scuttle
sectile9311973sectile
setose65114773s_etose
settle63915663s_ettle
sextile1438573sextile
shackle16409543shackle
shale85332833sha__le
shamble14149263shamble
shothole1445513shothole
shuttle1046103shuttle
skald104210173ska__ld
skat87037903skat___
skated114414883skat_ed
skater105015493skat_er
skaters113512963skaters
skates104219403skat_es
skating123613853skating
skats94621543skat__s
skiable1338883skiable
skiffle17225203skiffle
skite95120053skit__e
skittles1245763skittles
skydove1842083skydove
slate55438283slat__e
snaffle13216253snaffle
snathe94415113snat_he
sole46053673s___ole
sotol54917653s_otol_
sotols63714473s_otols
spackle15369573spackle
spaetzle1942243spaetzle
spale74929213spa__le
spangle1038403spangle
sparkle133710213sparkle
spate74731583spat__e
spathe115115693spat_he
spathose1345633spathose
spatula935893spatula
spatzles1935303spatzles
spittle937923spittle
sprattle1054763sprattle
stabile9312063stabile
stable83921643sta_ble
staddle9288093staddle
stale55637103s__tale
stanol6310723stanol_
stanols739733stanols
staple84415823sta_ple
startle72511123startle
statable10310703statable
statal61613223statal_
state56237333stat__e
stately10310223stately
statice92614033statice
stative102612933stative
stator64015483stato_r
stators73915583stators
statue66015323stat_ue
stature74410683stature
statute7419323statute
stele55026843s__tele
stile54931573s__tile
stoae55024263s__toae
stoke94922513s__toke
stoled74521593s__toled
stolen64315063s__tolen
stoles63927673s__toles
stone55431183s__tone
stope74727243s__tope
store56333813s__tore
stove85220253s__tove
style85519363s__tyle
suable83920553sua_ble
subtile91912623subtile
subtle82113433subt_le
subtone9310343subtone
swaddle12276743swaddle
swale85221593swa__le
swathe125514113swat_he
systoles1146483systoles
tattle64115653_tattle
tole46052903___tole
twattle1064273twattle
wattle94314213_wattle

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 Limit1340271426.04622167.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.48527554.5
 
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.