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

147 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
fleetly133632(None) 
alertly1046792alertly
featly123711752f_eatly
feebly1436652f_eebly
flatly123110212fl_atly
fleecily1644012fleecily
fleecy14266482flee_cy
fleet85932332fleet__
fleeted113310232fleeted
fleeter103210362fleeter
fleets96915062fleet_s
fleshly16346092fleshly
fluently1445132fluently
freely12310962free_ly
gleety10479192gleet_y
meetly1138672_meetly
sleekly14325192sleekly
sleety94112652sleet_y
sweetly1335592sweetly
adeptly1344183adeptly
alienly1037503alienly
beetle8311673_beetle
bleakly1634663bleakly
bluely113310083blue_ly
bluntly1235223bluntly
cheerly15417603cheerly
cleanly1236323cleanly
clearly1236663clearly
clemently1645063clemently
clerkly1643573clerkly
cleverly1643463cleverly
deeply1257013_deeply
deftly1336533_deftly
dulcetly1443023dulcetly
eely77725213__ee_ly
effetely1742693effetely
elderly1154953elderly
erectly1257483erectly
facetely1643853facetely
fadedly1535453fadedly
faintly1337083faintly
falsely1336013false_ly
fatly115716803f__atly
fealty122910223f_ealty
feckly18335963f_eckly
feeble1138253f_eeble
feel75233843f_ee_l_
feels85223043f_ee_ls
feet75352213f_eet__
felly114922803f__elly
ferly115517353f__erly
fettle93713123f_ettle
feyly14429513f__eyly
fierily1339023fierily
finely123011563fine_ly
firefly1635633firefly
firstly1335643firstly
fitly115114973f__itly
fixedly2133913fixedly
flakily1736293flakily
flecky18387653fl_ecky
fledgy14414913fl_edgy
flee76238793flee___
fleece11369903flee_ce
fleeced13358153fleeced
fleecer12368033fleecer
fleeces12399643fleeces
fleech14367343flee_ch
fleeing113511293fleeing
fleer86020773flee__r
fleered11309503fleered
fleers96015793flee_rs
flees85828753flee__s
fleetest1136723fleetest
fleeting122910323fleeting
fleetingly1743593fleetingly
fleshily1744533fleshily
fleshy15406283fl_eshy
fletch14388193fl_etch
fleury12417353fl_eury
flexibly2342733flexibly
flexile1735073flexile
fley106626853fl_e__y
flintily1434893flintily
flinty126112493flint_y
flirty12499143flirt_y
floaty124210943float_y
fluency1545353fluency
fluidly1434813fluidly
flukily1735213flukily
flutey125212523fl_utey
fluty114415643fl_ut_y
freckly19124593freckly
freeway1635603freeway
freshly16286833freshly
fretty1249223f_retty
fulgently1643543fulgently
gently103710913_gently
gleet65532343gleet__
gleeted9379323gleeted
gleets75315053gleet_s
glegly1134873gl_egly
greatly1137613greatly
greenly11408193greenly
ineptly1245083ineptly
inertly1038543inertly
keenly1336373_keenly
lastly93310873_lastly
lately93413843_lately
leally94012613_leally
lealty92910603_lealty
leanly93811503_leanly
leerily1037633_leerily
leery85919133_lee_ry
leet45957903_leet__
leets54927123_leet_s
leeway1255883_leeway
lefty115613563_left_y
levelly1335853_levelly
lewdly1334403_lewdly
liefly1266363_liefly
meekly1535193_meekly
neatly93812483_neatly
nettly9459453_nettly
overtly13268983overtly
pertly115312553_pertly
plenty11311413plent_y
queenly1944463queenly
queerly1934233queerly
quietly1945893quietly
seely84522633_see_ly
seemly1138433_seemly
selectly1346563selectly
sheerly13337703sheerly
silently1147483silently
slantly10399323slantly
sleeky13398963slee_ky
sleepily1344823sleepily
sleepy11479413slee_py
sleet55639133sleet__
sleeted83113223sleeted
sleets64318873sleet_s
steely93612573stee_ly
steeply1236293steeply
unmeetly1344073unmeetly
weekly1635313_weekly
wetly114511713__wetly

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 Limit1340271476.89319443.9
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.34524328.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.