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

121 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
misjoins173691(None) 
disjoins1647621disjoins
miscoins12311081miscoins
misjoin1637691misjoin_
disjoin1547642disjoin_
disjoint1649232disjoint
disjoints1745472disjoints
miscoin11311432miscoin_
misdoing1238802misdoing
misdoings1344422misdoings
misjoined1945452misjoined
mispoint121012362mispoint
mispoints13106632mispoints
missions10311902missions
adjoins1585983_adjoins
bisons83914373bis_o_ns
cissoids1145363cissoids
cojoins1638993_cojoins
conjoins1738133conjoins
discoids1239873discoids
discoing12511453discoing
disdains1037913disdains
disjoined1845833disjoined
disowns1136733dis_owns
distains9413603distains
eisweins1143383eisweins
emissions1146923emissions
enjoins1457333_enjoins
essoins737603_essoins
fibroins1346213fibroins
fissions1138033fissions
isatins7310773_isatins
joins125818413___joins
ligroins946823ligroins
mascons113411583masco_ns
masjids17175403masj_ids
masons83916513mas_o_ns
mastoids1177873mastoids
mesons83215843mes_o_ns
microns113814783micro_ns
midnoons1144403midnoons
midpoint13117493midpoint
midpoints14103803midpoints
midtowns1443243midtowns
mignons1037863migno_ns
mikrons13428413mikro_ns
milfoils1343893milfoils
millions101712433millions
mimeoing1336143mimeoing
minikins14208323minikins
minions93314623minio_ns
mirins83918903mi__rins
misaims11310113mis_aims
misaligns1244773misaligns
misbegins1444893misbegins
misbias1139083mis_bias
misbind1258273mis_bind
misbinds1345163mis_binds
misbound1344933misbound
miscodes13310423miscodes
miscoding1538183miscoding
miscoined1448443miscoined
miscooks1645463miscooks
miscopies1549613miscopies
miscount1299473miscount
miscounts1386413miscounts
miscuing1338733miscuing
misdoers1137103misdoers
misdoes10312493misdo_es
misdone10310863misdo_ne
misedits1147963misedits
miseries10320403miseries
misfits12279663mis_fits
misfocus1543453misfocus
misforms1545893misforms
mishits122513083mis_hits
misjoinder2052703misjoinder
misjoinders2152343misjoinders
misjoining2085293misjoining
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
musjids17185713musj_ids
muslins9312213mus_lins
omissions1146153omissions
pissoirs1044693pissoirs
pistons93016373pisto_ns
rejoins143111383_rejoins
sirloins836723sirloins
siskins1159583sis_kins
subjoins1745453subjoins
visions10311023visio_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 Limit1461621216.92021121.7
3Display Results1211210.0502420.0
 (SQL Overall)1786911217.39324170.3
 
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.