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

134 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
skatoles123614(None) 
skatole1135681skatole_
skatols1135521skatol_s
skates104219392skat__es
skatol1035712skatol__
skittles1245762skittles
spatzles1935302spatzles
stoles63927672s__toles
systoles1146472systoles
amatols938173amatol_s
amoles84122193__amoles
anoles64827423__anoles
atolls65511353__atolls
atones65225773__atones
azoles154614613__azoles
battles94517683_battles
brattles10199333brattles
cajoles163712103_cajoles
citoles9312553_citoles
diastoles1047493diastoles
diazoles1836323diazoles
escaroles1145273escaroles
espanoles1143943espanoles
haoles94919803_ha_oles
kales95730983_ka__les
kanteles1238123_kanteles
kathodes1646183_kathodes
kayles134712003_ka_yles
kayoes134710823_kayo_es
ketols104210763_ketol_s
ketones115014503_ketones
ketoses114912873_ketoses
kettles113411613_kettles
kittles113012493_kittles
paroles95025883_paroles
pistoles102514723pistoles
prattles10189403prattles
ratholes11312413_ratholes
rattles73217303_rattles
sables85026693s_a_bles
saddles95415743s_addles
safroles1136933safroles
sales56055593s_a__les
salols64017873s_alol_s
samples112815453s_amples
santols73513323santol_s
sapotes9313933s_apotes
sarodes84216143s_arodes
saroses73619333s_aroses
sates54949323s_at__es
satires72617573s_atires
satoris7317233s_atoris
scabbles14167983scabbles
scales84529313sca__les
scathes124515713scat_hes
scuttles1056503scuttles
seatless83213003seat_less
settles73916003s_ettles
sextiles1537643sextiles
shackles173010593shackles
shakoes144510013shako_es
shales94731253sha__les
shambles15159043shambles
shotholes1546183shotholes
shuttles1136543shuttles
skalds11437833ska__lds
skate94721543skat__e_
skated114414873skat__ed
skater105015483skat__er
skaters113512943skat_ers
skatings13326993skatings
skats94621533skat___s
sketches1746823sketches
skiffles18265703skiffles
skites104418033skit__es
skittle1135523skittle_
skyboxes2442673skyboxes
slatches131511523slatches
slates64934063slat__es
snaffles14246033snaffles
snatches131410713snatches
snathes104816493snat_hes
soles55547923s___oles
sotols63714453s_otol_s
spackles16319943spackles
spadones1137253spadones
spaetzles2042153spaetzles
spales84728103spa__les
spangles1138893spangles
sparkles143210483sparkles
spates85028173spat__es
spathes125116533spat_hes
spatulas1045473spatulas
spatzle1834573spatzle_
spittles1038333spittles
sprattles1174883sprattles
stabiles10311403stabiles
stables93219073sta_bles
staddles10258693staddles
stales65538293s__tales
stanols739733stanol_s
staples93617213sta_ples
startles82111963startles
stateless937563stateless
states64337083stat__es
statices102712343statices
statives112710793statives
stators73915553stato_rs
statues74614903stat_ues
statures83711113statures
statuses8409533statuses
statutes8368893statutes
steles63725663s__teles
stiles64328763s__tiles
stokes104821793s__tokes
stole54928813s__tole_
stoled74521593s__toled
stolen64315063s__tolen
stones65130033s__tones
stopes84525893s__topes
stores65533643s__tores
stoves93818923s__toves
styles94418653s__tyles
subtones10311373subtones
swaddles13296453swaddles
swales93920763swa__les
swatches16169963swatches
swathes134115513swat_hes
systole1035763systole_
tattles73616283_tattles
toles55147133___toles
twattles1154383twattles
viatores11257673viatores
wattles103814073_wattles

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621348.65616885.6
3Display Results1341340.0462913.0
 (SQL Overall)1786911348.87520134.2
 
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.