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 “sidles” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
sidles7472115(None) 
idles66720121_idles
sides65838361sid_es
sidle65124031sidle_
sidled84215171sidled
sidler74716961sidler
sidlers83414221sidlers
addles84216602addles
aides65336602aid_es
aidless83612072aidless
aisles64721142aisles
asides75118872asid_es
bibles104617642bibles
bides85536772bid_es
biles75542142bi_les
bindles104016452bindles
birles84920642birles
bridles104114472bridles
diddles103915072diddles
didies84621832didies
didoes85716962didoes
dindles93817242dindles
ediles74016972ediles
fiddles123212602fiddles
fidges114114382fidges
files85441272fi_les
filles94224522filles
girdles92210002girdles
hides95129422hid_es
ides57734232_id_es
idle55423762_idle_
idled74915212_idled
idler65015662_idler
idlers74012812_idlers
idlest74014862_idlest
isles54220562_isles
istles62814982istles
kindles123614842kindles
ladles74619542ladles
lidless8309272lidless
lisles63416282lisles
middles113415302middles
midges103516472midges
midleg1038552midleg
midlegs1156322midlegs
miles74645072mi_les
milles84526562milles
nides65229132nid_es
oodles73517182oodles
padles95221112padles
piddles114314272piddles
piles74742612pi_les
riddles93215022riddles
rides66140812rid_es
ridges85817002ridges
ridley10169542ridley
ridleys11145782ridleys
rifles94217702rifles
riles55343642ri_les
rilles64725502rilles
sables85026692sables
saddles95415742saddles
sades65239892sad_es
sadhes104715372sadhes
sales56055592s_ales
scales84529312scales
sedges83817792sedges
seidels838392seidels
selles64426982selles
shales94731252shales
sials54227242sial_s
sices75637272si_ces
sickles133417542sickles
side55444482sid_e_
sided74825952sid_ed
sidhe95315102sidhe_
sieges73816832sieges
sieves93216002sieves
siglos7311462siglos
sikes96236082si_kes
silds65520522si_lds
silex123417412si_lex
silks94620682si_lks
siller64026052siller
sillers73822092sillers
sillies73425072sillies
sills55135982si_lls
silos56029422si_los
silts55330822si_lts
similes92915232similes
simples113014942simples
sines55954822si_nes
singes74326852singes
singles83520432singles
sinless73014212sinless
sipes76036952si_pes
sirees64624582sirees
sires55945372si_res
sises55233832si_ses
sisses64520602sisses
sites56045432si_tes
sixes124526362si_xes
sixtes133612402sixtes
sizes146727762si_zes
sizzles15349632sizzles
slides73922182slid_es
smidges11448192smidges
smiles84522292smiles
socles8418452socles
soles55547922s_oles
spales84728102spales
spiles84227912spiles
spindles112710352spindles
stales65538292stales
steles63725662steles
stifles103013382stifles
stiles64328762stiles
stoles63927672stoles
styles94418652styles
sudses74114502sudses
swales93920762swales
swindles12319502swindles
swiples12339642swiples
tides64830152tid_es
tidies74721832tidies
tildes74513962tildes
tiles55542102ti_les
titles63719922titles
widdles123514342widdles
wides94832822wid_es
wiles85437872wi_les
windles113518492windles
yodles103714332yodles

Search took 4 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 Filter178691825510.1231452772.4
2DLD Change Limit825511332.95327955.0
3Display Results1331330.0462891.3
 (SQL Overall)1786911333.12257236.1
 
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.