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 “agilely” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
agilely113512(None) 
agile65122262agile__
agility1148652agility
agley96917332ag_le_y
facilely1644362facilely
fragilely1662432fragilely
gilly94321632_gil_ly
vilely1239442_vilely
ability12311443ability
acidly125211793aci_dly
actively1647063actively
acutely1246123acutely
adultly1143753adultly
affinely1743863affinely
afield1035953afi_eld
agedly1136463ag_edly
ageless8310343ageless
agelessly1343463agelessly
agleam9158623ag_leam
aglee65728493ag_le_e
aglet65534143ag_le_t
aglets73915683ag_lets
agly86821803ag___ly
aguishly1543613aguishly
aiglet74224193aigle_t
aiglets84012913aiglets
ailed66240283a_ile_d
airily93014823a_irily
alienly1037503alienly
allele64514563a_llele
alley85721673a_lle_y
ally76935643a__l_ly
alpinely1344343alpinely
amiably1438303amiably
anally9513503anal_ly
anile54634463anile__
anility10312723anility
apishly1535663apishly
aridly105513703ari_dly
ariel55228973ari_el_
ariels65119373ari_els
ariled75620323arile_d
avidly13548783avi_dly
axially1737233axially
axile126020513axile__
axilla13289573axil_la
bailey115015673baile_y
billy105525363_bil_ly
cagily12411563cagi__ly
childly1644803childly
chilly144113223chil_ly
cicely1338833_cicely
datively1545673datively
dilly94923783_dil_ly
direly10311553_direly
docilely1443993docilely
evilly1236593evil_ly
filly114424903_fil_ly
finely123011563_finely
frilly124111443fril_ly
futilely1444083futilely
gaiety10119373gai_ety
gaily95020973gai__ly
gainly1049323gai_nly
gallery11468743gallery
galley104215453galle_y
gallfly1433523gallfly
gally95026173_gal_ly
gamely124711913_gamely
giggly12518703_giggly
gill56336183_gil_l_
gilled84521633_gilled
giller74519733_giller
gills64728193_gil_ls
gimel8313353_gimel_
gimels938893_gimels
gingely12378193_gingely
girly94415293_gi_rly
glegly1134873_g_legly
gley85724653_g_le_y
glibly1236293_glibly
golly95121103_gol_ly
gulley104213163_gulley
gully94020683_gul_ly
hilly114422163_hil_ly
illy76925333__il_ly
likely13328133_likely
lively123310813_lively
mildly12318243_mildly
naively1335903naively
natively1446413natively
nicely1139493_nicely
oilily93111723_oilily
palely11311923_palely
primely1457713primely
ragingly1337863ragingly
rifely123710033_rifely
riley84420583_rile_y
ripely112511153_ripely
sagely102811383sag__ely
senilely1146093senilely
silly84527613_sil_ly
smiley114012303smile_y
snidely1136803snidely
solely93714213_solely
stalely1039213stalely
stilly93714073stil_ly
tactilely1443433tactilely
timely113410113_timely
tritely1039003tritely
uglily1036193ug_lily
vagally1435833vagal_ly
vagile10310543vagile__
vagility1546323vagility
vaguely1443693vag_uely
veiledly1543133veiledly
virilely1444033virilely
whitely16346473whitely
widely133311033_widely
wifely15429423_wifely
wildly13328123_wildly
wilily123310763_wilily
willy115321913_wil_ly
wisely122711713_wisely

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271247.20318607.1
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.40524131.1
 
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.