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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
secantly134598(None) 
scantly12419551s_cantly
decently1448012decently
peccantly1843952peccantly
recently1339432recently
scantily1337582s_cantily
scanty114014662s_cant_y
secant84023292secant__
secants93413892secant_s
secondly1443662secondly
secretly1345182secretly
secundly1443122secundly
slantly10399322s_lantly
vacantly1644072vacantly
arrantly1156103arrantly
beastly1277563be_astly
cantle84522153__cantle
canty105226803__cant_y
cecally1459393ceca_lly
decadently1753973decadently
decanal1038113decanal_
decant93524223decant__
decanted122310493decanted
decanter112510793decanter
decants103514443decant_s
defiantly1644153defiantly
elegantly1343983elegantly
errantly1175793errantly
exactly1953823_exactly
featly123711753fe_a_tly
gently103710913ge__ntly
leanly93811503le_an_ly
lucently1344973lucently
meanly115412043me_an_ly
natantly1144293natantly
neatly93812483ne_a_tly
operantly1444913operantly
peartly1267453pe_artly
pedantry1444053pedantry
pendantly1545463pendantly
pliantly1345783pliantly
recant83228683recant__
recanted112513513recanted
recanter101913153recanter
recants93217093recant_s
reliantly1245353reliantly
repandly1445023repandly
riantly1037613_riantly
saintly1039343s_aintly
sanely93114613s__anely
scaly104718723s_ca__ly
scant79735073s_cant__
scanted104114393s_canted
scanter94215183s_canter
scants85219723s_cant_s
scarily12311703s_carily
scatty115310653s_ca_tty
seamanly1345403seaman_ly
seconal9310073seconal_
seconals1047053seconals
securely1345073securely
sedately1245223sedately
sejant133114483sejant__
selectly1346563selectly
semantic1249553semantic
sentry92912053se__ntry
serenely1147623serenely
seventhly1843093seventhly
seventy1338033sevent_y
shantey134210043s_hantey
shanty124715123s_hant_y
silently1147483silently
slanty95114843s_lant_y
smartly12497433s_martly
spangly1336473s_pangly
squatly1946433squa_tly
straitly1136563straitly
tenantry1144263tenantry
truantly1144643truantly
verdantly1644333verdantly

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit146162808.11018022.4
3Display Results80800.0302666.7
 (SQL Overall)178691808.54620909.3
 
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.