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

175 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
malison93969(None) 
malisons1048781malisons
malign939852mali_gn
mansion9611542mansion
mason74820182ma__son
talion6317712tali_on
warison1037082warison
alien56425583_ali_en
align65016503_ali_gn
alimony1236013_alimony
alist56136783_alis_t
aliyos9349533_aliyos
aliyot93611713_aliyot
also46423443_al_so_
amnion84812053amni_on
anion55028813_ani_on
arisen65316793_arisen
arson55118833_a_rson
avion84218343_avi_on
aviso85713963_aviso_
avisos95410493_avisos
axion1211316913_axi_on
ballon84117493bal_lon
balloon93711433balloon
basion84315853basi_on
benison937123benison
bison75716983__bison
bolson8410683bol_son
caisson936593caisson
caldron1038153caldron
calico103414433calico_
calicos113913493calicos
camion103917193cami_on
cation83925503cati_on
classon937693classon
daikon11217243da_ikon
daimon9259713da_imon
dalapon1044893dalapon
dalton7311273dal_ton
damson938063da_mson
elision72311103_elision
empoison1243843empoison
emulsion1045923emulsion
falcon11310293fal_con
fanion94514323fani_on
foison948933_foison
gabion93211033gabi_on
galiot72322593gali_ot
galipot1049543galipot
galleon8278713galleon
gallon73715813gal_lon
galloon82910643galloon
garrison943983garrison
grison7310103_grison
halcyon1543923halcyon
halidom1386453halidom
halon86124863hal__on
helicon1237643helicon
imprison1244793imprison
kalian10312173kali_an
kation104315683kati_on
kelson1038153kel_son
liaison744473liaison
lion46334453__li_on
macon94519953ma__con
macron103615673ma_cron
madzoon1996063madzoon
mafiosi1244803mafiosi
mafioso1244453mafioso
mafiosos1343053mafiosos
magian9312833magi_an
maiden93512283ma_iden
mailbox1853563mailbox
maillot9312173maillot
mailman1137733mailman
mailmen1137273mailmen
mails76037783mails__
main65345523ma_i__n
maist75535683ma_is_t
maists85817573ma_ists
makimono1641943makimono
malaise9312673malais_e
malaises10312333malaises
males75049793males__
malic94525663mali__c
malice104818483mali_ce
malices114316623malices
maligns1038133maligns
malihini1344823malihini
maline84529093mali_ne
malines93625613malines
malkin122913153mal_kin
mallow114014743mal_low
malls76233433malls__
malms95021553malms__
malmsey1433623malmsey
malodor1044563malodor
maltol8310843mal_tol
maltose939793maltose
malts76331753malts__
mammon939643ma_mmon
manihot121112053manihot
manikin132110243manikin
manioc103914823mani_oc
manito8518693manito_
manitos9314053manitos
manitou938463manitou
mansions1069793mansions
marish114319063maris_h
marlin84220913marli__n
maroon83118203ma_roon
marron83717543ma_rron
mascon103612743ma_scon
masons83916513ma__sons
matin75132853mati__n
matron83918313ma_tron
matzoon1896473matzoon
mavin105722953mavi__n
mavis105622723mavis__
mavises122812993mavises
maximin1835263maximin
maxis145721563maxis__
melilot9311083melilot
melisma1146473melisma
melon73922083mel__on
melton8311553mel_ton
meson74118313m__eson
midiron1046003midiron
milksop1542833milksop
million91813143million
minion83416243mini_on
mirliton1044183mirliton
miso67229913m__iso_
misos76523293m__isos
mission9312743mission
morion86217733mori_on
motion85217553moti_on
mulish11311903mulis_h
mullion91911173mullion
multiton1087343multiton
nasion63914083nasi_on
nation64322803nati_on
nelson638423nel_son
orison6411663_orison
paisan84417073pa_isan
palimony1544313palimony
palish114718283palis_h
parson83817903pa_rson
passion9310883passion
poison8312223_poison
prison8514023_prison
pulsion938393pulsion
raisin62716923ra_isin
ramson8310463ra_mson
ration64226013rati_on
sadiron836043sadiron
salicin9311223salicin
salmon84614183sal_mon
salon55228553sal__on
saloon64418023sal_oon
samisen937673samisen
silicon9117533silicon
solion6616383soli_on
soliton7410233soliton
talions7314113tali_ons
talipot949723talipot
talisman1045553talisman
talon55824113tal__on
telson6310293tel_son
unison649033_unison
valise92917653valis_e
valises103516273valises
venison1036453venison
wanion93213063wani_on
warisons1136903warisons

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 Filter1786911340270.440406115.9
2DLD Change Limit1340271758.32616097.4
3Display Results1751750.0632777.8
 (SQL Overall)1786911758.82920239.1
 
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.