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

123 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
ladles7461954(None) 
lades65141271lad_es
ladies75124881ladies
ladle66320441ladle_
ladled85013481ladled
ladler74314931ladler
ladlers84613571ladlers
padles95221121padles
ables75935542_ables
addles84216602addles
adzes155913802_adzes
ales47067102_a_les
arles56735742_arles
axles125219472_axles
badges103917372badges
bales76250082ba_les
beadles103414732beadles
blades95221252blad_es
cables104527552cables
cades85440732cad_es
cadges104716712cadges
cadres94017932cadres
candles104422342candles
carles85435082carles
caudles103912812caudles
caules85927252caules
clades94920462clad_es
cradles103114132cradles
daddles104213802daddles
dadoes85616532dadoes
dales66439742da_les
dalles74222062dalles
dandles94218532dandles
dawdles12379162dawdles
eagles73819162eagles
fables114921672fables
fades94932862fad_es
fadges114814032fadges
farles96025782farles
gables94222332gables
gales65442482ga_les
glades84820342glad_es
hades96035112had_es
hadjes175210402hadjes
hales85449842ha_les
handles114020652handles
haoles94919802haoles
idles66720122_idles
jades135222112jad_es
kales95730982ka_les
kayles134712002kayles
labels84515682labels
laces76141762la_ces
laches116528352laches
ladder84617622ladder
ladders94115172ladders
laddies93715052laddies
lade56345982lad_e_
laded74232612lad_ed
laden65022192lad_en
ladens74516232ladens
lader65633722lad_er
laders74927762laders
lads56549132lad__s
lakes95737652la_kes
lalled74218752lalled
lalls55324132la_lls
lames75445542la_mes
lances84824102lances
landler84113202landler
landlers94312832landlers
landless94011172landless
lanes54946792la_nes
lapels83712042lapels
lapses85217692lapses
larees65323112larees
lares54852632la_res
larges74824232larges
lases54944762la_ses
lashes94831002lashes
lasses64827592lasses
lathes95127502lathes
latkes104715872latkes
lattes65324202lattes
laves86039152la_ves
lawless1037032lawless
laxes125430092la_xes
lazes145129572la_zes
lazies154418782lazies
leadless9248792leadless
ledges84918012ledges
lidless8309272lidless
lisles63416282lisles
lodes66436912lod_es
lodges86820152lodges
ludes65728852lud_es
macles107023222macles
madres93718182madres
mailes84329112mailes
males75049792ma_les
maples104819422maples
oodles73517182oodles
paddles113515642paddles
padle84522342padle_
padres95016982padres
pales75753802pa_les
parles86334402parles
raddles93615702raddles
rales54947492ra_les
sables85026692sables
saddles95415742saddles
sades65239892sad_es
sadhes104715372sadhes
sales56055592sa_les
sidles74721152sidles
tables84524892tables
tales55451372ta_les
vales85434262va_les
waddles124314842waddles
wades95634142wad_es
wadies105121202wadies
wales86142832wa_les
yodles103714332yodles

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 Filter178691825510.356501941.0
2DLD Change Limit825511232.23336968.7
3Display Results1231230.0502460.0
 (SQL Overall)1786911232.63967711.6
 
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.