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

251 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
unison64903(None) 
union54519791uni_on
unisons748421unisons
anion55028812ani_on
benison937122benison
bison75716982_bison
bunion83111312buni_on
foison948932foison
grison7310102grison
inion54620182ini_on
ninon55517382_ninon
niton55418282_niton
onion54320972oni_on
orison6411662orison
poison8312222poison
prison8514022prison
unicorn946512unicorn
unions64216752uni_ons
unipod946852unipod
unisex1358352unisex
unisonal845372unisonal
unrisen7229282unrisen
unsown9328432un_sown
unwon84512342un_won
venison1036442venison
amnion84812053amni_on
ancon75718233an_con
andiron848283andiron
anilin6417793anilin
anions64123033ani_ons
anis45746463anis__
anise55129703anis_e
anises64826693anises
anisic8313793anisic
anisole71010833anisole
anon46134853an__on
anyon85615223an_yon
arisen65316793arisen
arson55118833_arson
avion84218343avi_on
aviso85713963aviso_
avisos95410483avisos
axion1211316913axi_on
basion84315853basion
benisons1037043benisons
bisons83914373_bisons
bolson8410683bolson
boson76019733_boson
bunions92210473buni_ons
caisson936593caisson
chiton112612393chiton
cion613330913_ci_on
crimson1135643crimson
daikon11217243daikon
daimon9259713daimon
damson938063damson
disown1036953_disown
dobson936593dobson
dungeon9134553dungeon
durion7510963duri_on
eikon939463_eikon
elision72311103elision
enisle63412093enisle
ensign737523ensign
environ1044763environ
envision1145953envision
epigon937963epigon
fanion94514323fani_on
foisons1047613foisons
frisson1045313frisson
fusion939773fusi_on
gibson935123gibson
gipon84212413_gipon
giron66118993_giron
gnomon936183gnomon
godson857383godson
gonion73612833goni_on
grisons838993grisons
grunion835433gruni_on
guidon837373guidon
hisn79620933_his_n
hyson1138693_hyson
icon66922043__icon
ikon85814953__ikon
incision1047603incision
incisor955323incisor
inions64417003ini_ons
intron64215023intron
ion36051023__i_on
iron46728463__iron
junior1386143juni_or
kelson1038153kelson
knish1238603knis_h
lesion64715063lesion
lesson64412043lesson
liaison744473liaison
lion46334443_li_on
malison939693malison
mansion9611543mansion
mason74820183_mason
meson74118313_meson
minion83416243minion
miso67229903_miso_
misos76523293_misos
munis75022003munis__
munition1038763munition
munnion935863munnion
nasion63914083_nasion
nelson638423nelson
neon47026423_n_eon
nicol71113293_nicol
ninons64913773_ninons
nisei54214353_nisei
nisi45823243_nis_i
nisus56014393_nisus
nitons64614903_nitons
noniron738373noniron
noon47134623_n_oon
nylon82910513_nylon
onions64016433oni_ons
oniony9369703oni_ony
orisons7310563orisons
paisan84417073paisan
parson83817903parson
pension9412203pension
person83517873person
pinion83815893pinion
pinon76024533_pinon
pinyon11459763pinyon
pion67235293_pi_on
piso66727563_piso_
pisos76021063_pisos
piston83515923_piston
piton76121583_piton
poisons9310353poisons
prion75119993pri_on
prisons9313223prisons
ptisan8417973ptisan
pulsion938393pulsion
punish111411503punis_h
punition1038373punition
raisin62716923raisin
ramson8310463ramson
reason62616333reason
reunion737673reuni_on
risen54621883_risen
ronion63315643roni_on
scion72214993sci_on
season62714903season
seisin63715123seisin
seisor63712343seisor
son37761953___son
suasion739363suasion
telson6310293telson
tension7311803tension
tigon63914443_tigon
trigon74513103trigon
triton63914893triton
turion6313163turi_on
udon56017743u__don
unais53420773unais__
unakin10310963unakin
unban72114333un_ban
unborn83310813unborn
unbosom1144483unbosom
unbox1438753un_box
unclog956603unclog
unco66021403un_co_
uncool8610113uncool
uncos74117033un_cos
uncoy104111413un_coy
uncrown1236323uncrown
unction9310663unction
undo55620153un_do_
undone7914253un_done
uneven957913uneven
unfond10149113un_fond
ungot61718063un_got
unhewn12285253unhewn
unhood1039233unhood
unhook1347523unhook
unibody1343353unibody
unicorns1044773unicorns
unific1137463unific
uniform1247053uniform
unify113611113uni_fy
unipods1095703unipods
unique1558163unique
unironed939083unironed
unironic1046053unironic
unisize1647343unisize
unisonant954363unisonant
unisonous943803unisonous
unit45140073uni__t
unite54828383uni_te
united74421543united
uniter64619143uniter
unites65024853unites
uniting8315823uniting
units54923433uni_ts
unity84918493uni_ty
unknot1037413unknot
unknown1442673unknown
unman72715423un_man
unmoor836313unmoor
unmown11296093unmown
unopen838913unopen
unpen72913573un_pen
unperson1046383unperson
unpin72613243un_pin
unreason8104483unreason
unroof9410193unroof
unroot6315553unroot
uns35936763un_s__
unsawn9317463unsawn
unsay83212843un_say
unseen62012623unseen
unsent63820963un_sent
unset54532433un_set
unsew83912693un_sew
unsewn9298393unsewn
unsex123512633un_sex
unshod1067603unshod
unshorn1036943unshorn
unsold71410513un_sold
unsoncy1245513un_soncy
unsonsy1045023un_sonsy
unsound8158433un_sound
unspun865793unspun
unstop837473unstop
unsung736983un_sung
unsunk1036333un_sunk
unsworn1046843unsworn
unto45824283un_to_
untorn63012343untorn
untrod769853untrod
unused72012883unused
unwisdom1441813unwisdom
unwise9510803unwis_e
unwiser1037123unwiser
unwish1239093unwis_h
unworn93411333unworn
upon65817583u__pon
uprisen9227353uprisen
upsilon943583upsilon
venisons1136133venisons
vision9311313_vision
visor82512833_visor
wanion93213063wani_on
warison1037083warison
weason93210823weason

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162514.81323419.1
3Display Results2512510.0763302.6
 (SQL Overall)1786912515.26533939.4
 
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.