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

151 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
malisons104878(None) 
malison939691malison_
maligns1038132mali_gns
mansions1069792mansions
masons83916512ma__sons
talions7314112tali_ons
warisons1136902warisons
aliens65619213_ali_ens
aligns75312953_ali_gns
alimony1236013_alimony
aliyos9349533_aliyo_s
amnions93710913amni_ons
anions64123033_ani_ons
arsons63917213_a_rsons
avions94114393_avi_ons
avisos95410493_aviso_s
axions134713483_axi_ons
ballons93916963bal_lons
balloons103110523balloons
basions94213953basi_ons
benisons1037043benisons
bisons83914373__bisons
bolsons969483bol_sons
caissons1036283caissons
caldrons1138063caldrons
calicoes123911603calicoes
calicos113913493calico_s
camions113916133cami_ons
cations94524143cati_ons
classons1037703classons
daikons12186693da_ikons
daimons10249323da_imons
dalapons1145443dalapons
daltons8310403dal_tons
damsons1038013da_msons
elisions82210423_elisions
empoisons1343643empoisons
emulsions1145343emulsions
falcons1239123fal_cons
fanions103713073fani_ons
foisons1047613_foisons
gabions102410053gabi_ons
galiots82311323gali_ots
galipots1145213galipots
galleons9258443galleons
gallons83015953gal_lons
galloons9289703galloons
garrisons1043793garrisons
grisons838993_grisons
halcyons1644023halcyons
halidoms1485823halidoms
halons95720713hal__ons
helicons1337613helicons
imprisons1344913imprisons
kalians11310183kali_ans
kations114013663kati_ons
kelsons1137323kel_sons
liaisons844293liaisons
lions55923213__li_ons
macons104017243ma__cons
macrons113514893ma_crons
madzoons20124773madzoons
mafiosos1343053mafiosos
magians10310753magi_ans
maidens10349663ma_idens
maillots1037473maillots
mains75635113ma_i__ns
maists85817573ma_is_ts
makimono1641943makimono
makimonos1741653makimonos
malaises10312333malais_es
malices114316623mali_ces
malicious1346043malicious
malign939853mali_gn_
malihini1344823malihini
malihinis1443833malihinis
maline84529093mali__ne
malines93625613mali_nes
malkins133311803mal_kins
mallows123714323mal_lows
malmseys1541903malmseys
malodors1144973malodors
maltols939403mal_tols
maltoses1039863maltoses
mammons1048513ma_mmons
manihots13126443manihots
manikins14189723manikins
maniocs113611443mani_ocs
manitos9314053manito_s
manitous1039173manitous
mansion9611543mansion_
marishes13512553marishes
marlins93420483marli__ns
maroons92615553ma_roons
marrons93216973ma_rrons
mascons113411583ma_scons
mason74820183ma__son_
matins84527783mati__ns
matrons93517633ma_trons
matzoons19105083matzoons
mavins115119183mavi__ns
mavises122812993mavis_es
maximins1944533maximins
melilots1046553melilots
melismas1245713melismas
melons84117713mel__ons
meltons9410923mel_tons
mesons83215843m__esons
midirons1145883midirons
milksops1642853milksops
millions101712433millions
minions93314623mini_ons
mirlitons1144113mirlitons
misos76523293m__iso_s
missions10311903missions
morions94014643mori_ons
motions94215003moti_ons
mullions101910353mullions
nasions73112383nasi_ons
nations74720563nati_ons
nelsons738003nel_sons
orisons7310563_orisons
paisans93614753pa_isans
palimony1544313palimony
parsons93516873pa_rsons
passions10310583passions
poisons9310353_poisons
prisons9313223_prisons
pulsions1037713pulsions
raisins72715343ra_isins
ramsons939563ra_msons
rations74123433rati_ons
sadirons936033sadirons
salicins10310933salicins
salmons93713263sal_mons
salons63823693sal__ons
saloons74415323sal_oons
samisens1035483samisens
silicons10107163silicons
solions7513753soli_ons
solitons849593solitons
talion6317713tali_on_
talipots1045623talipots
talismans1143833talismans
talons64019443tal__ons
telsons739223tel_sons
unisons748423_unisons
valises103516273valis_es
venisons1136133venisons
wanions104011373wani_ons
warison1037083warison_

Search took 10 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.420425454.8
2DLD Change Limit1461621518.70316794.4
3Display Results1511510.0632396.8
 (SQL Overall)1786911519.18619452.5
 
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.