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

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
fixedly213391(None) 
mixedly2033981mixedly
fadedly1535452fadedly
fiddly14328482fi_ddly
finely123011562fine_ly
firefly1635632firefly
fixed165416952fixed__
tiredly1136802tiredly
vexedly2143462vexedly
vixenly2043192vixenly
addedly1344293addedly
agedly1136463_agedly
biasedly1443953biasedly
bifidly1684233bifidly
cicely1338833cice_ly
cowedly1635703cowedly
datedly1236023datedly
dazedly2134063dazedly
diddly12389573di_ddly
direly10311563dire_ly
faxed166220533faxed__
feebly1436653f_eebly
feignedly1742223feignedly
felly114922803f__elly
ferly115517353f__erly
fetidly1435013fetidly
feyly14429513f__eyly
fickly18318533fi_ckly
fiddle113613383fi_ddle
field95015323fi_e_ld
fields104211043fi_elds
fierily1339023fierily
fiery114714793fi_e_ry
fifed125115973fifed__
fifthly1943093fifthly
figuredly1742313figuredly
filed95331903filed__
filly114424903fi__lly
filmily1535733filmily
finally13310103finally
fined94930503fined__
finery124512893fine_ry
fireclay1644183fireclay
fired94829743fired__
firedog1244473firedog
firmly1436663fi_rmly
firstly1335643firstly
fishily1637643fishily
fitly115114973fi__tly
fixable19218193fixable
fixer154717833fixe__r
fixers165112983fixe_rs
fixes154723593fixe__s
fixity19427803fix_ity
fledgy14414913f_ledgy
fleetly1336323fleetly
fluidly1434813fluidly
fondly13299043f_ondly
forcedly1744803forcedly
forkedly1944323forkedly
foxed165115213foxed__
foxily1947253fox_ily
freely12310963f_reely
friendly1544383friendly
frigidly1643123frigidly
giftedly1642933giftedly
idly85617323_i__dly
jadedly1934013jadedly
kindly14358843ki_ndly
liefly1266363li_efly
likely13328133like_ly
lively123310813live_ly
lividly1434783lividly
mazedly2234433mazedly
mildly12318243mi_ldly
miserly12329823miserly
mixed155717253mixed__
mutedly1345753mutedly
nakedly1534403nakedly
nicely1139493nice_ly
nixed135714223nixed__
notedly1136883notedly
piddly13319143pi_ddly
pixel143911903pixe_l_
pixels15478533pixe_ls
redly94217203__redly
rifely123710033rife_ly
rigidly1235533rigidly
ripely112511153ripe_ly
sixthly2042873sixthly
tiddly11308783ti_ddly
timely113410113time_ly
timidly1334593timidly
unitedly1245793unitedly
unmixedly2242273unmixedly
veiledly1543153veiledly
vilely1239443vile_ly
vividly1744233vividly
wickedly2142793wickedly
widely133311033wide_ly
wieldy13476183wi_eldy
wifely15429423wife_ly
wildly13328123wi_ldly
wingedly1644013wingedly
wisely122711713wise_ly

Search took 7 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.403443402.0
2DLD Change Limit1340271056.50320610.0
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.93625762.8
 
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.