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

149 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
lenitions93947(None) 
lenition8310081lenition_
dentitions1148852dentitions
editions9310402_editions
enations83316902_enations
ignitions1045802ignitions
lections102413842le_ctions
legations102711922legations
lenities8315942leniti_es
leniting9312352leniti_ng
lenitives1247502lenitives
lunations9310722lunations
mentions10312892men_tions
monitions11310882monitions
munitions1138172munitions
petitions11511082petitions
punitions1137922punitions
renditions1149182renditions
seditions1039012seditions
venations12311722venations
venditions1445522venditions
additions1186333additions
adnations1039753adnations
aerations9317903aerations
agnations10310033agnations
alienations1147883alienations
ambitions1346343ambitions
auditions1078753auditions
benisons1037043beni_sons
benthons1337973ben_thons
cognitions1346043cognitions
coitions10312853_coitions
conations111318903conations
conditions13410103conditions
crenations12511693crenations
decisions1248383decisions
definitions1545603definitions
delations102616593delations
deletions102610933deletions
demotions1258443demotions
dentations11413633dentations
dentins83419223den_ti_ns
dentition1049633dentition_
depictions1546893depictions
derisions1038843derisions
detritions1148953detritions
deviations14311163deviations
devotions1356593devotions
donations101112353donations
edition8310853_edition_
elations83719123_elations
elections112414973elections
elevations1338633elevations
elisions82210423_elisions
elutions82513053_elutions
emotions10610283_emotions
enation73419233_enation_
envisions1245613_envisions
evictions14228623_evictions
fenthions1544233fenthions
fetations12511383fetations
flections14239213fle_ctions
fruitions12106113fruitions
functions1437743functions
gelations102513093gelations
genitives1346663genitives
genitors937423genit_ors
gentians937563gen_tians
herniations1447403herniations
ignition946533ignition_
ignitrons1042993ignitrons
inanitions1046383inanitions
junctions1835943junctions
kenotrons1344523kenotrons
lavations1238973lavations
laxations1637623laxations
lecithins1443983lecithins
lectins92515003le_cti_ns
lection92614863le_ction_
legation92412933legation_
legions84611783le__gions
lengthens1343353lengthens
lenites7818443lenit__es
lenitive1148493leniti_ve
lentils73912973len_ti_ls
lentisks1244413len_tisks
lentoids947443len_toids
lentos65317403len_t_o_s
leptins92412693le_pti_ns
leptons91910433le_pt_ons
lesions73813873le__sions
levigations1546213levigations
levitations1448293levitations
levities11310713leviti_es
lewissons1241743lewissons
lexicons1743893lexi_cons
libations112510443libations
ligations102111993ligations
lineations1039543lineations
lobations11219613lobations
locations112512743locations
locutions11207063locutions
lotions74614763l__otions
lunation8311923lunation_
luxations1637273luxations
mediations13310983mediations
mentations12312583mentations
mention9314373men_tion_
monition10311723monition_
munition1038763munition_
nations74720563__nations
negations102811963negations
nitons64614903__nit_ons
notions74014483__notions
pensions10311693pen_sions
perditions1348873perditions
petition10711753petition_
planations1238723planations
positions11811503positions
prenotions1248293prenotions
punition1038373punition_
reactions11711713reactions
recisions1139913recisions
reeditions1147653reeditions
reignitions1244553reignitions
relations92418333relations
relictions12310023relictions
religions1086603religions
remotions1149703remotions
rendition1058933rendition_
revisions1238593revisions
sanctions1138873sanctions
sections102714703se_ctions
sedations10311253sedations
sedition939333sedition_
seditious1046493seditious
sensations1059853sensations
seriations10316683seriations
tensions8310223ten_sions
tuitions838283_tuitions
unctions1039733_unctions
venation11513503venation_
vendition1345693vendition_
venetians1244673venetians
venisons1136133veni_sons
vernations13310333vernations
vexations1937753vexations
volitions1288663volitions
zonations18139313zonations

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411497.44019978.6
3Display Results1491490.0602483.3
 (SQL Overall)1786911497.92022562.0
 
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.