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

234 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
mansion961154(None) 
mansions1069791mansions
amnion84812052amn_ion
anion55028812_an_ion
basion84315852ba_sion
fanion94514322fan_ion
malison939692malison
manioc103914822man_ioc
mascon103612742ma_scon
mason74820182ma_s_on
mention9314372mention
minion83416242min_ion
mission9312742mission
monsoon938492monsoon
munnion935862munnion
nasion63914082na_sion
passion9310882passion
pension9412202pension
scansion1045692scansion
tension7311802tension
wanion93213062wan_ion
action84719683_action
amnio75218053amn_io_
amnions93710913amn_ions
amnios84912523amn_ios
amotion9710473amotion
ancon75718233_an_con
andiron848283_andiron
anions64123033_an_ions
anon46134853_an__on
antlion7310293_antlion
anyon85615223_an_yon
arsino64113513_arsino
arson55118833_ars_on
assign736783_assign
avion84218343_a_vion
axion1211316913_a_xion
banian8315383ban_ian
basin75026923ba_si_n
basions94213953ba_sions
bassoon937613bassoon
bastion9312473bastion
benison937123benison
bunion83111313bun_ion
caisson936593caisson
camion103917193ca_mion
campion133011413campion
cannon84514443can_non
canon74725303can__on
canso75019403cans_o_
cansos84915383cans_os
canton85722993can_ton
canyon114512033can_yon
caption113513693caption
carrion9312673carrion
casino84317553ca_sino
cassino93512433cassino
cation83925503ca_tion
caution93013523caution
cession939813cession
chanson1238043chans_on
consign1038773consign
damson938063dams_on
danio6319783dan_io_
danios7314603dan_ios
dimension1244743dimension
elision72311103elision
elusion72310953elusion
emanation11910783emanation
emersion1047733emersion
emission1047673emission
emulsion1045923emulsion
enation73419233enation
ensign737523_ensign
erasion7311963erasion
erosion7311113erosion
evasion1036753evasion
expansion1844443expansion
faction122613333faction
fanions103713073fan_ions
fanon84619013fan__on
fashion1337843fashion
fission1038733fission
fusion939773_fusion
gabion93211033ga_bion
ganglion1044393ganglion
gascon9339723ga_scon
gonion73612833gon_ion
hansom11219153hans_om
impassion1344863impassion
inion54620183_in_ion
kamsin1238323kamsi_n
kation104315683ka_tion
lampion11278303lampion
lesion64715063_lesion
macon94519953ma__con
macron103615673ma_cron
madzoon1996063madzoon
magian9312833ma_gian
magnesian1244713magnesian
magneton1144943magneton
main65345523ma__i_n
malign939853ma_lign
malisons1048783malisons
malkin122913153malki_n
mammon939643ma_mmon
manakin131810643manakin
mandioca1354113mandioca
mangier104114063mangier
mangily1339753mangily
mango85724323man_go_
mangos94319333man_gos
manhood1338993manhood
mania75634153man_i_a
maniac103917973man_iac
manias84029033man_ias
manic94629443man_i_c
manics103919933man_ics
manihot121112053manihot
manikin132110243manikin
manila84518303man_ila
manioca11358943man_ioca
maniocs113611443man_iocs
manito8518693man_ito
manitos9314053manitos
manitou938463manitou
manitu8315823man_itu
mankind1437773mankind
manlier92414023manlier
manlike133012783manlike
manlily1238743manlily
mannan85413623man_nan
mannikin14215503mannikin
manning103616383manning
mannish121710693mannish
mannite9312903mannite
mannitol1044043mannitol
mano66536813man__o_
manor78023933man__or
manos74933623man__os
mans66354553mans___
mansard1049313mansard
manse75528233mans__e
manses84225513mans_es
mantic104120903manti_c
mantid93820383manti_d
mantids103113623mantids
mantis83926033manti_s
manwise1239183manwise
margin94016843margi_n
marlin84220903marli_n
maroon83118203ma_roon
marron83717543ma_rron
martian93514683martian
martin84122523marti_n
mascons113411583ma_scons
mascot104016073ma_scot
masons83916513ma_s_ons
massicot1246583massicot
massier93615223massier
massif11412533massi_f
massifs1237743massifs
massing104318023massing
massive12289773massive
matin75132853ma_ti_n
matron83918313ma_tron
mattin84416633matti_n
matzoon1896473matzoon
mavin105722953ma_vi_n
mayvin1436523mayvi_n
menazon1846053menazon
menshen1236803menshen
mensing103915103mensing
mentions10312893mentions
mesian84315503m_esian
meson74118313m_es_on
million91813143million
minions93314623min_ions
missions10311903missions
monaxon1644913monaxon
monition10311723monition
monsoons1047343monsoons
monuron937463monuron
morion86217733m_orion
morrion959003morrion
motion85217553m_otion
mullion91911173mullion
munition1038763munition
munnions1035273munnions
muntin82915183munti_n
myosin113410763myosi_n
nandin7313033nandi_n
nankin1039673nanki_n
nasions73112383na_sions
nation64322803na_tion
omission1046533omission
onion54320973_on_ion
paction112713963paction
panino8315683pan_ino
pansies94521983pansies
parson83817903pars_on
passions10310583passions
pensione1039773pensione
pensions10311693pensions
pinion83815893pin_ion
plosion939113plosion
pulsion938393pulsion
raisin62716923raisi_n
rampion11298583rampion
ramson8310463rams_on
ransom82410943rans_om
ration64226013ra_tion
ronion63315643ron_ion
sanction1049533sanction
sasin54626573sa_si_n
scansions1145323scansions
session739763session
sponsion1045623sponsion
suasion739363suasion
taction93213023taction
talion6317713ta_lion
tampion11298663tampion
tannin62613923tanni_n
tansies74521243tansies
tensions8310223tensions
torsion7310803torsion
union54519793_un_ion
unison649033_unison
venison1036443venison
version10310923version
vision9311313_vision
wanions104011373wan_ions
wanton94413813wan_ton
warison1037083warison

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 Filter1786911340270.500357382.0
2DLD Change Limit1340272346.72019944.5
3Display Results2342340.0932516.1
 (SQL Overall)1786912347.31324434.7
 
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.