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

152 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
isles5422056(None) 
aisles64721141aisles
idles66720121idles
isle45121701isle_
isled64615991isled
islet54527551islet
islets64513081islets
istles62814981istles
lisles63416281lisles
ables75935542ables
aisle55223192aisle_
aisled74516182aisled
ales47067102_ales
arles56735742arles
ashes86230612ashes
asses55629282asses
axles125219472axles
bales76250082bales
bibles104617642bibles
biles75542142biles
birles84920642birles
bises75435622bis_es
boles75448602boles
coles76055062coles
dales66439742dales
deles65139252deles
dishes104622652dishes
dismes95617672dismes
disses75225962disses
doles67843752doles
enisles72312602enisles
eses45336102es_es
esnes54817362esnes
esses56422972esses
files85441272files
filles94224522filles
fishes125221342fishes
gales65442482gales
gules64831042gules
hales85449842hales
hirsles101510072hirsles
hisses94719352hisses
holes84748652holes
ices66129642i_ces
ides57734242i_des
idle55423772idle_
idled74915212idled
idler65015662idler
idlers74012812idlers
idlest74014862idlest
iglus6609932iglus
ilea45931462i_lea
ileus54616892i_leus
ilex115822032i_lex
ilks87218572i_lks
iller54821292iller
illest63615722illest
ills47030422i_lls
ingles74420872ingles
inkles103515652inkles
inlet53732402inlet
inlets63915572inlets
insoles73516242insoles
ires45639282i_res
isbas71010402isbas
isms66213472is_ms
issei568572issei
isseis638562isseis
issues648802issues
istle52214712istle_
ivies84215762ivies
ixtles13217062ixtles
joles125230832joles
kales95730982kales
kisses104217332kisses
les35663072__les
lisle53916722lisle_
males75049792males
miles74645072miles
milles84526562milles
mises74740562mis_es
misled94719312misled
mislies92922282mislies
misses85130872misses
moles74747922moles
mules75034292mules
ogles65223182ogles
oles46453472_oles
orles55326212orles
oses46641512os_es
pales75753802pales
peles75738082peles
piles74742612piles
pishes114722102pishes
pisses84525082pisses
pistes85325632pistes
poles75351002poles
pules74538812pules
rales54947492rales
rifles94217712rifles
riles55343642riles
rilles64725502rilles
rises55244042ris_es
roles56747982roles
rules55234252rules
sales56055592sales
sees45361052_sees
sels46345982_sels
shes75734352_shes
sices75637272sices
sides65838372sides
sidles74721152sidles
sikes96236082sikes
silds65520532silds
silex123417412silex
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sisses64520602sisses
sites56045432sites
sixes124526362sixes
sizes146727762sizes
sled55334372_sled
sleds64418852_sleds
slew76228232_slew
slews86220352_slews
sloes54728872_sloes
slues54527172_slues
soles55547922soles
sues46247652_sues
tales55451372tales
teles54536002teles
tiles55542102tiles
titles63719922titles
toles55147132toles
tules54532792tules
uses44931112us_es
vales85434262vales
vises84427772vis_es
voles86234042voles
wales86142842wales
wiles85437872wiles
wises85633192wis_es
wishes124920952wishes
wisses94619602wisses
wyles114615322wyles
yules84521582yules

Search took 3 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.360496363.9
2DLD Change Limit538001521.89028465.6
3Display Results1521520.0503040.0
 (SQL Overall)1786911522.30077691.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.