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

116 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
aglet6553414(None) 
aglee65728491aglee
aglets73915681aglets
agley96917331agley
aiglet74224191aiglet
eaglet73722581eaglet
abet610547942a_bet
able66340532able_
abled86926832abled
abler75624312abler
ables75935542ables
ablest84721832ablest
agate66525142agate
age47154332ag_e_
aged67334252ag_ed
agee56241492ag_ee
agent65829642agent
ager55935842ag_er
ages55844592ag_es
agger76420892agger
agile65122262agile_
agist66325582agist
agleam9158622agleam
aglow94711962aglow
agly86821802agl_y
agree65226032agree
ague55725922ague_
agues64919052agues
aiglets84012912aiglets
aigret73720022aigret
ailed66240282ailed
ale36572342a_le_
alec66430062a_lec
alee46652322a_lee
alef76340692a_lef
alert54740652a_lert
ales47067102a_les
alit46155692a_lit
allee54932122allee
alley85721672alley
allot54933872allot
alt36467962a_l_t
amulet8419572amulet
angle64528872angle_
angled84219072angled
angler74017862angler
angles74426702angles
anklet105618732anklet
applet105917432applet
argle65421562argle_
argled85314542argled
argles75218482argles
arles56735742arles
armet76739452armet
armlet84118192armlet
asset55932262asset
auklet104216832auklet
axle116424602axle_
axled135315812axled
axles125219472axles
baguet9316102baguet
ballet84733972ballet
blet66247672_blet
cablet104429462cablet
callet84536762callet
camlet104426582camlet
caplet104226812caplet
culet76040342culet
eagle64219482eagle_
eagled82914042eagled
eagles73819162eagles
eaglets84111662eaglets
egret63327312egret
filet85540162filet
gale56347322gale_
galea64722932galea
gales65442482gales
gallet73630852gallet
gelt56448012_gelt
get47467462_g_et
giglet83920272giglet
gled65631142_gled
glee55239062_glee
gleet65532342_gleet
gleg66219802_gleg
glen56027202_glen
gley85724652_gley
glut56331292_glut
goglet84618582goglet
guglet84018222guglet
hamlet113722792hamlet
haslet93222712haslet
inlet53732402inlet
islet54527552islet
let36481472__let
maglev1237022maglev
magnet9320662magnet
mallet84433052mallet
ogle56325052ogle_
ogled75915962ogled
ogler65917442ogler
ogles65223182ogles
owlet83324462owlet
palet74650802palet
pallet84232652pallet
piglet93420922piglet
reglet73724232reglet
relet54749822relet
sallet63734542sallet
samlet84126562samlet
tablet84227642tablet
unlet54133332unlet
valet84337872valet
varlet9423502varlet
wallet93327092wallet
wiglet105519152wiglet

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.1261418182.5
2DLD Change Limit538001161.86028924.7
3Display Results1161160.0303866.7
 (SQL Overall)1786911162.01688636.4
 
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.