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

154 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
monition1031172(None) 
monitions11310881monitions
munition1038761munition
admonition1344442admonition
cognition1247012cognition
coition9314312co_ition
conation101420882conation
condition12411162condition
donation91513782donation
ignition946532ignition
lenition8310082lenition
mention9314372men_tion
monitive1349992monitive
monitor9310722monit_or
motion85217552mo__tion
munitions1138172munitions
position10912192position
punition1038372punition
volition1179172volition
zonation171410722zonation
abolition1147053abolition
addition1096893addition
admonitions1444243admonitions
adnation9310783adnation
agnation9311723agnation
amanitin1048463amaniti_n
ambition1246563ambition
ammoniation1545903ammoniation
ammunition14103813ammunition
amotion9710473amo__tion
audition979173audition
bonito8313433bonit_o_
bonitos939733bonit_os
coaction12310773coaction
coalition1148703coalition
cognation12310753cognation
cognitions1346043cognitions
coitions10312853co_itions
conations111318903conations
concision1348493concision
conditions13410103conditions
conidian1168383conidian
connation11314263connation
conniption1446273conniption
contrition12411423contrition
conviction1748183conviction
cooption1288343cooption
demolition1376983demolition
dentition1049633dentition
dominion11147033dominion
donations101112353donations
dotation91412733dotation
edition8310853_edition
emanation11910783emanation
emotion9711303emo__tion
enation73419233_enation
foliation121110793foliation
fruition11106103fruition
function1337843function
gonion73612833gon__ion
ignitions1045803ignitions
ignitron943203ignitron
imposition1446533imposition
inanition947293inanition
iodation9310383iodation
ionization19411273ionization
junction1736203junction
lenitions939473lenitions
lobation102110553lobation
location102113913location
locution10227663locution
lotion65716523lo__tion
lunation8311923lunation
manikin132110243maniki_n
manito8518693manit_o_
manitos9314053manit_os
manitou938463manit_ou
mansion9611543man_sion
mediation12312293mediation
mentation11313983mentation
mentions10312893men_tions
minikin13258983miniki_n
minion83416243m__inion
modillion1244203modillion
monaxon1644913mon_axon
monecian1247283monecian
monetise10311473monetise
monetize1949983monetize
monistic12311303monisti_c
monitors10310823monitors
monitory1347853monitory
monotint10413713monotint
monotone10310153monot_one
monotony1347073monot_ony
monsoon938493mon_soon
monuron937463mon_uron
morion86217733mo__rion
morrion959003mo_rrion
motions94215003mo__tions
motivation1548083motivation
mouton8410853mo_ut_on
munitioned1353943munitioned
munnion935863mun_nion
muntin82915183mun_ti_n
mutation101412883mutation
nation64322803__nation
niton55418283__nit_on
nonaction1149443nonaction
nonfiction1546303nonfiction
nonillion945463nonillion
noniron738373noni_ron
nonunion845583nonunion
notation81414603notation
notion64516583__notion
novation111710013novation
onion54320973_on__ion
opinion946793_opinion
option83612713_o_ption
oration71617713_oration
ovation101510023_ovation
ozonation1845673ozonation
petition10711753petition
phonation1439393phonation
ponton83217643pon_t_on
pontoon93010703pon_toon
portion9615493po_rtion
positions11811503positions
positron1096903positron
potation101716783potation
potion84519573po__tion
premonition1547353premonition
pronation11415703pronation
punitions1137923punitions
rendition1058933rendition
rogation91612053rogation
ronion63315643ron__ion
rotation81615453rotation
sanction1049533sanction
sedition939333sedition
solation8916153solation
soliton7410233solit_on
solution889593solution
sonication12411183sonication
sorption1037513sorption
sortition946703sortition
tuition738823_tuition
unction9310663_unction
venation11513503venation
vendition1345693vendition
vocation132311983vocation
volitions1288663volitions
volution1198603volution
wonton93410963won_t_on
zonations18139313zonations

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.423422437.4
2DLD Change Limit1461621547.64019131.2
3Display Results1541540.0602566.7
 (SQL Overall)1786911548.12321998.2
 
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.