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

105 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
aglee6572849(None) 
agee56241491ag_ee
aglet65534141aglet
agley96917331agley
agree65226031agree
alee46652321a_lee
allee54932121allee
glee55239061_glee
abele76323252abele
able66340532abl_e
abled86926832abled
abler75624312abler
ables75935542ables
ackee115825372ackee
agape85614842agape
agate66525152agate
agave95314032agave
agaze156113662agaze
age47154332ag__e
aged67334252ag_ed
agene65621582agene
ager55935842ag_er
ages55844592ag_es
agger76420892agger
aggie73415012aggie
agile65122262agile
aglare7312432aglare
agleam9158622agleam
aglets73915682aglets
aglow94711972aglow
agly86821802agl_y
agone65924552agone
agreed84712502agreed
agrees74915322agrees
ague55725922ag_ue
agues64919052agues
aiglet74224192aiglet
ailed66240282ailed
ajee115928232a_jee
akee85936812a_kee
alae45643752a_lae
ale36572342a_l_e
alec66430062a_lec
alef76340692a_lef
ales47067102a_les
algae65319622algae
allees64521482allees
allege74314652allege
allele64514562allele
alley85721672alley
alme65832162a_lme
aloe45540192a_loe
anele55628832anele
angle64528872angl_e
angled84219092angled
angler74017862angler
angles74426702angles
argle65421562argl_e
argled85314552argled
argles75218482argles
arles56735742arles
asleep847282asleep
awee76336642a_wee
axle116424602axl_e
axled135315812axled
axles125219472axles
bailee84526012bailee
callee84327292callee
eagle64219482eagl_e
eagled82914042eagled
eagles73819162eagles
eaglet73722582eaglet
flee76238792_flee
gale56347322gal_e
galea64722942galea
galeae74717452galeae
galere73716682galere
gales65442482gales
gee45359202_g_ee
gelee63626982gelee
ghee85726112_ghee
glebe85016442_glebe
gled65631142_gled
glede75517832_glede
gleed75320572_gleed
gleek105315102_gleek
glees65027592_glees
gleet65532342_gleet
gleg66219802_gleg
glen56027202_glen
gley85724652_gley
glue55628492_glue
gree56641562_gree
lee36068142__lee
maglev1237022maglev
mallee84525592mallee
melee73729102melee
ngwee9311072ngwee
ogee57629882og_ee
ogle56325052ogl_e
ogled75915962ogled
ogler65917442ogler
ogles65223182ogles
ragee65432662rag_ee
raggee84217602raggee

Search took 2 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.343520965.0
2DLD Change Limit538001051.59333772.8
3Display Results1051050.0333181.8
 (SQL Overall)1786911051.96990752.2
 
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.