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

159 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
idles6672012(None) 
ides57734231id_es
idle55423761idle_
idled74915211idled
idler65015661idler
idlers74012811idlers
idlest74014861idlest
isles54220561isles
sidles74721151sidles
ables75935542ables
addles84216602addles
adzes155913802adzes
aides65336602aid_es
aidless83612072aidless
aisles64721142aisles
ales47067102_ales
arles56735742arles
axles125219472axles
bales76250082bales
bibles104617642bibles
bides85536772bid_es
biles75542142biles
bindles104016452bindles
birles84920642birles
boles75448602boles
bridles104114472bridles
coles76055062coles
dales66439742dales
dees56356632_dees
deles65139252deles
dels56745472_dels
dices86434242dices
diddles103915072diddles
didies84621832didies
didoes85716962didoes
dies55653522_dies
dikes105831332dikes
dills65530972dills
dimes85833042dimes
dindles93817242dindles
dines66449152dines
dites66339152dites
dives95832402dives
does56554472_does
doles67843752doles
dues56045502_dues
dyes85331892_dyes
edges75718742edges
ediles74016982ediles
fiddles123212602fiddles
fidges114114392fidges
files85441272files
filles94224522filles
gales65442482gales
girdles92210002girdles
gules64831042gules
hales85449842hales
hides95129422hid_es
holes84748652holes
ices66129642i_ces
idea59122772id_ea
ideas65919012ideas
idem76121062id_em
idlesse834192idlesse
idly85617322idl_y
idols65514132idols
ids47535472id__s
idylls10425252idylls
idyls9498802idyls
iglus6609932iglus
ilea45931462i_lea
ileus54616892i_leus
ilex115822032i_lex
ilks87218572i_lks
iller54821292iller
illest63615722illest
ills47030422i_lls
indies73822782indies
indoles83716362indoles
indues73515262indues
ingles74420872ingles
inkles103515652inkles
inlet53732402inlet
inlets63915572inlets
ires45639282i_res
isle45121702isle_
isled64615992isled
islet54527552islet
islets64513082islets
istles62814982istles
ivies84215762ivies
ixtles13217062ixtles
joles125230832joles
kales95730982kales
kindles123614842kindles
ladles74619542ladles
les35663072__les
lidless8309272lidless
lisles63416282lisles
males75049792males
middles113415302middles
midges103516482midges
midleg1038552midleg
midlegs1156322midlegs
miles74645072miles
milles84526562milles
moles74747922moles
mules75034292mules
nides65229132nid_es
odes57243242od_es
odyles10348562odyles
ogles65223182ogles
oles46453472_oles
oodles73517182oodles
orles55326212orles
padles95221122padles
pales75753802pales
peles75738082peles
piddles114314272piddles
piles74742612piles
poles75351002poles
pules74538812pules
rales54947492rales
riddles93215022riddles
rides66140812rid_es
ridges85817012ridges
ridley10169542ridley
ridleys11145782ridleys
rifles94217702rifles
riles55343642riles
rilles64725502rilles
roles56747982roles
rules55234252rules
sales56055592sales
sides65838362sid_es
sidle65124032sidle_
sidled84215172sidled
sidler74716962sidler
sidlers83414232sidlers
soles55547922soles
tales55451372tales
teles54536002teles
tides64830152tid_es
tidies74721832tidies
tildes74513962tildes
tiles55542102tiles
titles63719922titles
toles55147132toles
tules54532792tules
vales85434262vales
voles86234042voles
wales86142832wales
widdles123514342widdles
wides94832822wid_es
wiles85437872wiles
windles113518492windles
wyles114615322wyles
yodles103714332yodles
yules84521582yules

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 Filter178691538000.546327272.9
2DLD Change Limit538001592.98318035.5
3Display Results1591590.0463456.5
 (SQL Overall)1786911593.57549983.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.