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

120 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
misjoin163769(None) 
disjoin1547641disjoin
miscoin11311431miscoin
misjoins1736911misjoins
disjoins1647622disjoins
disjoint1649232disjoint
miscoins12311082miscoins
misdoing1238802misdoing
misjoined1945452misjoined
mislain9311242mislain
mispoint121012362mispoint
mission9312742mission
adjoin14107293_adjoin
bison75716983bis_o_n
cissoid1037343cissoid
cojoin1539503_cojoin
conjoin1638203conjoin
discoid11311243discoid
discoing12511453discoing
disdain938513disdain
disjoined1845833disjoined
disjoints1745473disjoints
disown1036953dis_own
distain8313783distain
eiswein1043503eiswein
emission1047673emission
enjoin1357833_enjoin
essoin638193_essoin
fibroin1246473fibroin
fission1038733fission
histoid1139823histoid
isatin6412213_isatin
join116724833___join
ligroin848043ligroin
mascon103612743masco_n
masjid16187323masj_id
mason74820183mas_o_n
mastoid10711233mastoid
meson74118313mes_o_n
micron103714283micro_n
midnoon1044683midnoon
midpoint13117493midpoint
midtown1343673midtown
mignon937953migno_n
mikron12318503mikro_n
milfoil1264383milfoil
million91813143million
mimeoing1336143mimeoing
minikin13258983minikin
minion83416243minio_n
mirin75023153mi__rin
misaim10311853mis_aim
misalign1146433misalign
misbegin1344673misbegin
misbind1258273mis_bind
misbound1344933misbound
miscode12310413miscode
miscoding1538183miscoding
miscoined1448443miscoined
miscook1546473miscook
miscopy1636663miscopy
miscount1299473miscount
miscuing1338733miscuing
misdid10510573mis_did
misdo85413193misdo__
misdoer1048633misdoer
misdoes10312493misdoes
misdoings1344423misdoings
misdone10310863misdone
misedit10311043misedit
misfit112813833mis_fit
misform1437513misform
misgrown1443983misgrown
mishit112618203mis_hit
misjoinder2052703misjoinder
misjoining2085293misjoining
misknown1742533misknown
mislaid1039303mislaid
mislie83219153mis_lie
mislit83019693mis_lit
mislying1437843mislying
mismove1437083mismove
mismoving1745783mismoving
miso67229913mis_o__
misos76523293mis_o_s
mispaint121111893mispaint
mispen10312173mis_pen
misplan1147773misplan
mispoints13106633mispoints
mispoise1248263mispoise
misprint12912973misprint
missaid10310303missaid
missing103619073mis_sing
missions10311903missions
missis84417503mis_sis
missort9314653missort
missound1145113missound
missout9412663missout
missuit9911303missuit
misthink1745433misthink
misting103623383mis_ting
mistook1337153mistook
mistrain10311943mistrain
misunion1084943misunion
misusing1138893misusing
misword1338413misword
miswrit1249413miswrit
misyoke1635823misyoke
misyoking1944923misyoking
musjid16216953musj_id
muslin8312213mus_lin
omission1046533omission
pissoir945043pissoir
piston83515923pisto_n
rejoin134012243_rejoin
sirloin747593sirloin
siskin1079783sis_kin
subjoin1645443subjoin
viscoid1337023viscoid
vision9311313visio_n

Search took 7 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.406440125.6
2DLD Change Limit1340271205.98322401.3
3Display Results1201200.0304000.0
 (SQL Overall)1786911206.41927837.8
 
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.