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

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
erectly125748(None) 
directly1455302directly
erect74129332erect__
erected103213992erected
erecter93113392erecter
erectile1039512erectile
erector93513812erector
erects84116182erect_s
exactly1953822exactly
freckly19124592freckly
greatly1137612greatly
perfectly1944112perfectly
selectly1346562selectly
abjectly2242413abjectly
adeptly1344183adeptly
alertly1046793alertly
archly1437353ar_chly
ardently1247453ardently
areally10411243areally
breathy15328033breathy
bristly12178063bristly
brittly12165973brittly
correctly1644963correctly
crackly18397703crackly
decently1448013decently
deftly1336533_deftly
drecky16486333drec_ky
earnestly1243013earnestly
eely77725213e_e__ly
eerily92913563e_erily
eject145016043eject__
ejecta15337393eject_a
ejected17297653ejected
ejector16378603ejector
ejects15409953eject_s
elect74327033elect__
elected102812613elected
electee92513243electee
elector93313263elector
electro92810033electro
elects83315003elect_s
erectable131210093erectable
erecters102611613erecters
erectility1546263erectility
erecting112415063erecting
erection102115513erection
erective13311833erective
erectors103514263erectors
erosely1038083erosely
errantly1175793errantly
eruct74022353eruct__
eructed10228653eructed
eructs83610793eruct_s
evenly1236993eve_nly
expertly2044703expertly
featly123711753_featly
feckly18335963_feckly
fervently1845143fervently
fleetly1336323fleetly
freckle16106643freckle
freely12310963fre_ely
freshly16286833freshly
fretty1249223fre_tty
gently103710913_gently
greenly11408193greenly
greyly13316543gre_yly
gristly11187333gristly
ineptly1245073ineptly
inertly1038543inertly
meetly1138673_meetly
merely111312593mere__ly
neatly93812483_neatly
nettly9459453_nettly
orectic1138823orectic
overtly13268983overtly
pertly115312553_pertly
prettily1337283prettily
pretty11510873pre_tty
pricily142710283pricily
prickly18367893prickly
priestly1345843priestly
racily11715173_racily
raptly11338913_raptly
rattly94111543_rattly
really93315613_really
realty92713693_realty
recall83815723_recall
recently1339423recently
recopy1339043_recopy
recta74220263_rect_a
rectal84418133_rectal
rectally1339713_rectally
recti73619623_rect_i
rectify1536453_rectify
recto74520803_rect_o
rector84019753_rector
rectory123512733_rectory
rectos85718783_rectos
rectum103411283_rectum
rectus83314633_rectus
redly94217203_re_dly
reechy14367823reec_hy
reedily1179613reedily
reentry1038033reentry
refly113914563_re_fly
rely75428953_re__ly
reply104015853_re_ply
retry84718083_re_try
richly1438003_richly
secretly1345183secre_tly
serenely1147623serenely
strictly1345813strictly
sweetly1335593sweetly
treacly1237093treacly
treaty94414353treat_y
trebly1138973tre_bly
trembly1435523trembly
trestle72611363trestle
trickly16369893trickly
urgently1245623urgently
wetly114511713_we_tly
wreathy16326063wreathy
wrestle10298843wrestle

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.406440125.6
2DLD Change Limit1340271236.92319359.7
3Display Results1231230.0432860.5
 (SQL Overall)1786911237.37224239.1
 
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.