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 “miscoins” 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
miscoins1231108(None) 
miscoin11311431miscoin_
misjoins1736911misjoins
discoids1239872discoids
discoing12511452discoing
disjoins1647622disjoins
mascons113411582masco_ns
miscodes13310422miscodes
miscoding1538182miscoding
miscoined1448442miscoined
miscooks1645462miscooks
miscopies1549612miscopies
miscount1299472miscount
miscounts1386412miscounts
miscuing1338732miscuing
misdoing1238802misdoing
misdoings1344422misdoings
misjoin1637692misjoin_
mispoint121012362mispoint
mispoints13106632mispoints
missions10311902missions
bicorns11338763bi_corns
biscuits1245133biscuits
bisons83914373bis_o_ns
ciscoes113610733cisco_es
ciscos104711133cisco__s
cissoids1145363cissoids
coins75834553___coins
discerns1138163discerns
discing113914593disc_ing
discoid11311243discoi_d
discords1238593discords
discos94915213disco__s
discount11811313discount
discounts1287823discounts
discrowns1544663discrowns
disdains1037913disdains
disjoin1547643disjoin_
disjoint1649233disjoint
disjoints1745473disjoints
disowns1136733dis_owns
distains9413603distains
eisweins1143383eisweins
emissions1146923emissions
essoins737603_essoins
fibroins1346213fibroins
ficins113513983fi_c_ins
fissions1138033fissions
gascons10289103gasco_ns
icons76516493_i_co_ns
isatins7310773_isatins
ligroins946823ligroins
macons104017243m_aco_ns
mascon103612743masco_n_
mascots113910343masco_ts
masons83916513mas_o_ns
mastoids1177873mastoids
mescluns1243343mescluns
mesons83215843mes_o_ns
miching152911803mi_ching
microns113814783mi_crons
midnoons1144403midnoons
midpoint13117493midpoint
midpoints14103803midpoints
midtowns1443243midtowns
mignons1037863migno_ns
mikrons13428413mikro_ns
milfoils1343893milfoils
millions101712433millions
mimeoing1336143mimeoing
mincing123314333minc_ing
minikins14208323minikins
minions93314623minio_ns
mirins83918903mi__rins
misacting1439083misacting
misaims11310113mis_aims
misaligns1244773misaligns
misbegins1444893misbegins
misbias1139083mis_bias
misbind1258273mis_bind
misbinds1345163mis_binds
misbound1344933misbound
miscalls1239003miscalls
miscasts1238353miscasts
mischief1846423mischief
mischiefs1943063mischiefs
mischoice18124253mischoice
mischoices19124013mischoices
miscite11314383misc_ite
miscites12313783miscites
misciting1439673misciting
misclaims1544593misclaims
misclass1246843misclass
miscode12310413misco_de
miscoded1437983miscoded
miscoining1597763miscoining
miscolor1245603miscolor
miscolors1345863miscolors
miscook1546473misco_ok
miscooking1945003miscooking
miscopied1647163miscopied
miscopy1636663misco_py
miscopying2044973miscopying
miscues11312393misc_ues
miscuts1139183misc_uts
misdoers1137103misdoers
misdoes10312493misdo_es
misdone10310863misdo_ne
misedits1147963misedits
miseries10320403miseries
misfits12279663mis_fits
misfocus1543453misfocus
misforms1545893misforms
mishits122513083mis_hits
misjoined1945453misjoined
mislain9311243mislain_
mislies92922283mis_lies
mislying1437843mislying
mismoves1537293mismoves
mismoving1745783mismoving
misos76523293mis_o__s
mispaint121111893mispaint
mispaints13106183mispaints
mispens11311073mis_pens
misplans1238863misplans
mispoise1248263mispoise
mispoises1348353mispoises
misprint12912973misprint
misprints13107223misprints
missies93423983mis_sies
missing103619073mis_sing
mission9312743mission_
missis84417503mis_si_s
missorts1038323missorts
missound1145113missound
missounds1243533missounds
missouts1037623missouts
missuits1078023missuits
misthink1745433misthink
misthinks1843353misthinks
misting103623383mis_ting
mistrains11511353mistrains
misunions1154533misunions
misusing1138893misusing
miswords1446603miswords
misyokes1735513misyokes
misyoking1944923misyoking
mucins102712513m_uc_ins
mucoids1237423m_ucoids
muscids12187973musc_ids
muscling1337853muscling
muslins9312213mus_lins
niacins938543niac_ins
nicotins1058173ni_cotins
omissions1146153omissions
picolins1239853pi_colins
piscina1177043pisc_ina
piscinas1275483pisc_inas
piscine11610973pisc_ine
piscos105112593pisco__s
pissoirs1044693pissoirs
pistons93016373pisto_ns
recoins94019243_recoins
ricins83618703ri_c_ins
scions82612243__scions
scorns85713023__scorns
sirloins836723sirloins
siskins1159583sis_kins
viscoid1337023viscoi_d
viscoses1338343viscoses
viscount1396783viscount
viscounts1484583viscounts
viscous1238833visco_us
visions10311023visio_ns
zircons1854963zirco_ns

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621756.75021653.6
3Display Results1751750.0762302.6
 (SQL Overall)1786911757.24924650.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.